Compare data

[Dimitris]

Hello, in a table there are two fields F1 and F2 that may contain similar
data. What I want is to find out which records have the same data in both
fields F1 and F2 and have the number "1" entered in field CH.
So if data of F1 similar with data of F2, 1 must be entered in CH.

Can someone tell me how to do that please?

Thank you
Dimitris

 

[Jerry Whittle]

SELECT YourTable.*
FROM YourTable
WHERE [YourTable].F1=[YourTable]![F2] AND [YourTable].CH = 1;