query problem

[Jeremy]

I want to be able to set up a query that will return
results if 2 fields are equal in value.

I am quering tables through an ODBC connection and I want
to have results return to me if the number of accepted
pieces equal the total in the job.

Total lot qty = 100

Number of Accepted pieces = 100

Sometimes there might be over 3000 pieces and sometimes as
few as 25. Is there any way to get a query to do this? I
can't seem to figure it out.

Please help!

Thanks in advance

Jeremy

 

[[MVP] S.Clark]

Create a query that sums the qty per lot #. Call it qryQtyPerLotNo

Create a second query, add qryQtyPerLotNo. Add the Lot Table. Link via
LotNo's.

THEN compare if the Lot pieces = Total qty.


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 

[Jeremy]

Thanks for the answer, but I figured it out another way.

I made an expression column and had the [lot number] -
[accepted number]

To finish, I put the criteria for this column to equal
zero and it works like a charm!

Thanks again, though!