Access 2002 Help

M

ML

I am using Access 2002. I want to create a text box in the detail section of
a report with an expression that carries out this action: Display the records
in Field A only where the records are not equal to records in Field B. How do
I do that?
 
A

Arvin Meyer [MVP]

ML said:
I am using Access 2002. I want to create a text box in the detail section
of
a report with an expression that carries out this action: Display the
records
in Field A only where the records are not equal to records in Field B. How
do
I do that?
Click to expand...


You need to write a query and use that as the Recordsource for your report.

In the query add a column, like:

CheckValue: IIf([FieldA]=[FieldB],-1,0)

Then in the criteria for that alias column, put a 0 to get only those
records.
 
Top