query to test if fields have the same value

Why not do that in the WHERE clause instead ?

mx

Example:

SELECT Table1.*
FROM Table1
WHERE (((Table1.FIELD1)="abc") AND ((Table1.FIELD2)="abc") AND ((Table1.FIELD3)="abc"));

If not, what do you have so far?

mx

The values will never be the same.

Also It needs to be a calculated field.  Something like:
Expr1: ([fld_2007]=[fld_2008])=([fld_2007]=[fld_2009])=([fld_2008]=[fld_2009])

Not following:

"that tests if three fields have the same value "

"The values will never be the same."

?

Let me clarify:  the value we are looking for will never be the same.  In other words we can't test for "ABC" like you did in your second post.  The values in my fields could be any numeric combination (it is a text field as there can be leading zeros).

ok ... did you see my post @ http:#a37229162  ?

mx

That works.  I shortened it to:

=[fld_2008]) And ([fld_2007]=[fld_2009]) And ([fld_2008]=[fld_2009])

Thanks

cool.

mx