Report to show a query result and a table result

[coffeeman]

This may be a real simple thing to do, but for some reason I am stuck.

We receive a material in and have a quantity and material lot code that we begin with that gets entered into a form and populates a Receiving Table. When the material is run for a given product, I type into a Daily Production form the amount produced and it calculates how much a given material is used. I have a report that pulls the total material by lot code that has been used given a date range.

Is there a way to create a report that can have the quantity received for a given material by its lot code and the quantity used by the date range entered?

Also, I would like to calculate the difference between the two and a %shrinkage.

Can someone help me with this?

Thank you for your help.

 

[ArtMiles]

This should be easy to do if you base the report on a query. If you need help with it post your database and I will look at it for you.

Art