How to specify fieldname Not Equal To fieldname in an OpenOffice.org Base query

Let's say that you have a whole bunch of data. You're the head of HR and you have thousands of employees. You want to figure out which ones you need to talk to about new benefits because they've changed their health insurance plan from one year to another. You just need to figure out which are the ones who changed. How do you do that?

You create a query that says "find me all the people for whom Plan08 field does not equal Plan09".

OK, good. But what's the syntax?

Design View

<>  is how you say not equal

and then you just put square brackets around the fieldname.

so in the field for Plan08 you just put   <>[Plan09]

Here's some example data. You need to have the fields set up so they have the value for each employee's choice for health plan for 08, and then again for what they're switching to for 09.

 

The data needs to be in or connected to a database file, an ODB file.

Then you open your database .odb file containing that data, and you click the Queries icon at the side.

You have to create the query in design view or in SQL view, you can't use the wizard.

In design view it's as I showed before, and in SQL it's just "Plan08" <> "Plan09".

Here's how it looks in design view.

 

and here's the results when you click the green-checkmark Run Query icon.

Comments

[WOW GOLD]

Nice job! Thanks for your information.

------------------
http://www.vcsale.com/

[gold56465]

Take a look at our price of wow gold. You will find it is a loyal and reliable store of cheap wow goldfor sale online. You may compare the price then buy wow

gold from us . It will be a great fun that you will save huge money. We know what a gamer need so that we will provide you a really instant way of delivery,

if you buy world of warcraft gold, gold wow from us. Just place your order to buy wow gold from us then feel the world class service.
http://veryge.com/

[fgds]

gold from us . It will be a great fun that you will save huge money. We know what a gamer need so that we will provide you a really instant way of delivery,