Finding unequal fields

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.
 
G

Graham Mandeno

Hi Mate

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel formula help for calculating freight. 2
Query to select values after a certain date 0
Max Function 1
Trying to create a report that will list unmatched records by Ticket Primary Key 0
"Group By" makes Simple Query Run FOREVER 8
linking tables 3
Checkbox will not check 5
MS ACCESS 1

Top