how can I exclude records if they equal?

D

Dani

I would like to exclude all the records in my query if the [orderqty]
and the [receivedqty] equal. Both fields are in the same table. Is
this possible? Danielle
 
R

Randy Harris

Dani said:
I would like to exclude all the records in my query if the [orderqty]
and the [receivedqty] equal. Both fields are in the same table. Is
this possible? Danielle
Click to expand...

Sure. You would simply add a WHERE clause to the query:

WHERE orderqty <> receivedqty
 
D

Douglas J Steele

Assuming you're creating your query through the GUI, put

<> [receivedqty]

on the Criteria line under [orderqty]
 
D

David Lloyd

Danielle:

Yes, this is possible. For example:

SELECT OrderQty, ReceivedQty
FROM MyTable
WHERE [OrderQty]<>[ReceivedQty]

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


I would like to exclude all the records in my query if the [orderqty]
and the [receivedqty] equal. Both fields are in the same table. Is
this possible? Danielle
 
Top