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?
<> 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.