Minimum Reorder

B

Bob Quintal

=?Utf-8?B?Sm9obiBQYXVsIEFuZ2FsYSBQaWdhbw==?=
Good day,

I have this Inventory Monitoring running and i came up with an
idea of Minimum Reorder. I would like to run a report where all
items that is under the specified Miniumum Qty will be displayed
in a report. How can i do that?

I have a table for the main inventory, item id, item description,
etc. I have there a field for Qty and Reorder Qty. Now how can i
make a report that will display only the certain items that Qty on
Hand are below the Minimum Qty?

Please help...

Thanks in advance...

John Paul Angala Pigao
Step 1: create a query using the design tool.
Use your inventory table.
In the Criteria row for [Qty On Hand], put
< [Minimum Qty]
Save and run the query.
Build a report based on this query.
 
J

John Paul Angala Pigao

Good day,

I have this Inventory Monitoring running and i came up with an idea of
Minimum Reorder. I would like to run a report where all items that is under
the specified Miniumum Qty will be displayed in a report. How can i do that?

I have a table for the main inventory, item id, item description, etc. I
have there a field for Qty and Reorder Qty. Now how can i make a report that
will display only the certain items that Qty on Hand are below the Minimum
Qty?

Please help...

Thanks in advance...

John Paul Angala Pigao
 

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

Revised Calculation 11
calculating a remainder field 0
Calculating inventory w/ blank field results 4
Running total on a report 2
Negative Numbers 5
Inventory Report 5
SubQuery 1
Inventory Transaction Problem 1

Top