Inventory Activity Query For Report?

N

niuginikiwi

I have table and relationships scenario like what MVP Allen Browne has on his
site at: http://www.allenbrowne.com/AppInventory.html
which is:
tblAcq----<tblAcqDetails>----tblPacks---<tblOrderDetails>---tblOrders

tblAcq and tblAcqDetails process incoming packs and tblOrders and
tblOrderDetails process outgoing details. tblPacks holds the packs product
records.

I want to come up with a query that I will supply the following criteria
through a form to produce a report.
Criterias will be a Date Range which will filter AcqDate from tblAcq and
OrderDate from tblOrders. Another criteria will filter PackName in tblPacks.

So I get a report that looks something like this:

Between FromDate And ToDate
PackName UnitsIn UnitsOut UnitsOnHand
F47 50 20 30
B46 100 50 50

and so on...

I know what I want but I am finding it hard to get there.
Can someone help me please?
 

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

Periodic Stock Level Report Question? 3
Query For Report Question? Help 0
Sales Summary Date Range Filter Question? 4
One query for report and Excel 3
Parameters for Pass-thru query (Help!) 0
Specific Age Query for a Date Range 3
Form Entered Parameters for Pass-thru query 0
Running balance and balance b/f 3

Top