Finding unequal fields

  • Thread starter Thread starter Mate
  • Start date Start date
M

Mate

I have a query pulling from two different tables. One of
the tables contains an estimated freight charge, and the
other table contains the actual freight charge. How could
I create a query that pulls out entries where the
estimated and actual were not equal? Any help is much
appreciated as always. Thanks, mate.
 
Hi Mate

In the Criteria cell of the actual freight charge column of your query, add:
<>[EstimatedFreightCharge]
 
Back
Top