query problem


J

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
 
Ad

Advertisements

M

[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
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Ad

Advertisements

J

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!
 

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

Query problem 1
Query Problem 2
Query problem 0
Query Problem 4
Query Problem 3
query problem 2
Query Problem 9
query problem 4

Top