how can I exclude records if they equal?

[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

 

[Randy Harris]

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

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

WHERE orderqty <> receivedqty

 

[Lynn Trapp]

Select *
From YourTable
Where [Orderqty] <> [Receivedqty];

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[Douglas J Steele]

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

<> [receivedqty]

on the Criteria line under [orderqty]

 

[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