Criteria comparing two fields

[Metrazal]

I have a situation where I am running a query and I do not want to include any results were field3 = field5. Is this possible using the criteria?




Thanks,

Met

[orange]

What is the query code (SQL)?

[JoeM]

Assuming that the fields don't contain any null values, you would just have something like the following criteria in your SQL code:

WHERE [Field3]<>[Field5]

In the Query Builder, you could do this going under the Field3 field in your grid, and placing the following on the Criteria row for that field:

<>[Field5]

[Metrazal]

JoeM

Exactally what I needed.

Thanks,

Met