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]
 
You must log in or register to reply here.

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

Max Function 1
"Group By" makes Simple Query Run FOREVER 8
Query question 1
expression question 6
Query with minimum field value 1
linking tables 3
Two table with same child table 3
Max Function in a query 2

Back
Top