D
DissentChick
Hi there, I have a fairly simple question for you. I have the standard
inventory type form where my inventory level total is calculated from a
subreport made up of items ordered, received, etc. I built a report that will
give me all of the transaction information for any products in a certain date
range, except for a current inventory level. I have posted the query
information below, my goal is to have the inventory total for each item on
the report. Many thanks in advance, if you need more info please let me know!
Thank you!
SELECT DISTINCTROW Products.ProductName, [Inventory Transactions].*
FROM Products INNER JOIN [Inventory Transactions] ON Products.ProductID =
[Inventory Transactions].ProductID
WHERE ((([Inventory Transactions].TransactionDate)>=[forms]![Report Date
Range]![BeginDate] And ([Inventory
Transactions].TransactionDate)<=[forms]![Report Date Range]![EndDate]));
inventory type form where my inventory level total is calculated from a
subreport made up of items ordered, received, etc. I built a report that will
give me all of the transaction information for any products in a certain date
range, except for a current inventory level. I have posted the query
information below, my goal is to have the inventory total for each item on
the report. Many thanks in advance, if you need more info please let me know!
Thank you!
SELECT DISTINCTROW Products.ProductName, [Inventory Transactions].*
FROM Products INNER JOIN [Inventory Transactions] ON Products.ProductID =
[Inventory Transactions].ProductID
WHERE ((([Inventory Transactions].TransactionDate)>=[forms]![Report Date
Range]![BeginDate] And ([Inventory
Transactions].TransactionDate)<=[forms]![Report Date Range]![EndDate]));