N
neenmarie
I have a report to show inventory transactions. First the user opens a form
that has text boxes to enter criteria. The underlying query for the report
uses the criteria entered on the form. (Beginning Date, Ending Date and Job
Number)
This report shows the user each inventory transaction for a specific job
between dates. It has the following Sorting and Grouping on the report with
each InventoryOperation Totalled in its footer:
Job - Header
PartNumber - Footer
InventoryOperation - Footer
InventoryLocation - Footer
TransType - Ascending
Date - Ascending
But, I also need a beginning inventory balance for each Operation (balance
before the date range entered on the form) that I will then add to the Footer
total for a current inventory balance as of the ending date entered.
I'd like to use DSum or DLookUp for the date and job number. I also need to
connect the correct operations/locations within the report.
I have a query that uses the date criteria on the form to total all
transactions for each operation < the Beginning Date Entered. This is what I
tried on the report to bring in the beginning inventory balance for each
operation. I tried to put this in the header
=DLookUp("[IQ]","qryTUsub2","[JN]=[JobNumb] and [FP]=[FPN] and
[IPN]=[InventoryPN] and [IL]=[InventoryLocation]")
I just get an error. Any ideas? Is my syntax wrong or is the whole premise
off?
that has text boxes to enter criteria. The underlying query for the report
uses the criteria entered on the form. (Beginning Date, Ending Date and Job
Number)
This report shows the user each inventory transaction for a specific job
between dates. It has the following Sorting and Grouping on the report with
each InventoryOperation Totalled in its footer:
Job - Header
PartNumber - Footer
InventoryOperation - Footer
InventoryLocation - Footer
TransType - Ascending
Date - Ascending
But, I also need a beginning inventory balance for each Operation (balance
before the date range entered on the form) that I will then add to the Footer
total for a current inventory balance as of the ending date entered.
I'd like to use DSum or DLookUp for the date and job number. I also need to
connect the correct operations/locations within the report.
I have a query that uses the date criteria on the form to total all
transactions for each operation < the Beginning Date Entered. This is what I
tried on the report to bring in the beginning inventory balance for each
operation. I tried to put this in the header
=DLookUp("[IQ]","qryTUsub2","[JN]=[JobNumb] and [FP]=[FPN] and
[IPN]=[InventoryPN] and [IL]=[InventoryLocation]")
I just get an error. Any ideas? Is my syntax wrong or is the whole premise
off?