Access 2002 Help

  • Thread starter Thread starter ML
  • Start date Start date
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?
 
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.
 
Back
Top