How to Display Records whose Sum Reaches the value of enougher Field

J

JohnR

Hi can anyone answer this q?

How can i add the values of a specified field i.e Stock Level of a Specified Product where the product has more than one entry in the recordset because of different locations i.e GRN 1001 Stock Description Pallet 1m *1m Stock Level 20
GRN 1002 Stock Description Pallet 1m *1m Stock Level 30
GRN 1003 Stock Description Pallet 1m *1m Stock Level 30
Until the Value i.e stock level equals i.e. the Required level for the JOb and display the Separate records needed i.e if required is 50 then displays records GRN 1001 + GRN 1002

THis is for a maufacturing piking list
 

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

Move Multiple Values In Column To New Record 1
Condition and equation problems 4
Populating a null field in record with previous record value 0
Comparing data between a field and the values in a query 1
Query to Delete certain fields not records 1
Problems with "indirect sorting" in a form 1
Access 2003 (ADP): Problems with "indirect sorting" in a form 0
Append Non-Duplicate & Updated Records 8

Top