M
MichelleNH
I have a query called qryInventory. It takes information from tables in my
database and creates running sum of our inventory levels in our warehouse
(InvLvl). These numbers are put into a report (based on qryTransPropNum
essentially the same as qryInvLvl but narrows the date range) and grouped by
item (PropertyNumber) and sorted by date (TransactionDate). To generate this
report you need to input the starting and ending dates for the period of
interest. For the life of me I cannot find away to display the final InvLvl
in my TransactionDate footer. In an attempt to discover the problem I put
the InvLvl in the Details section of the report and found when I set the
control source of a text box to InvLvl in the TransactionDate footer, it was
returning the first value returned by the query for the correct property
number, but it is undesirable when there are multiple transactions in the
date range. DLast returns the last value for all property numbers. I tried
to use variations on the following expression:
DLookup("[InvLvl]","qryInventory",DMax("[TransactionDate]","qryTransPropNum","[PropertyNumber]=[PropertyNumber]))
But to no avail. That particular version generated "#Error". Anyone have
any suggestions? Thanks in advance.
database and creates running sum of our inventory levels in our warehouse
(InvLvl). These numbers are put into a report (based on qryTransPropNum
essentially the same as qryInvLvl but narrows the date range) and grouped by
item (PropertyNumber) and sorted by date (TransactionDate). To generate this
report you need to input the starting and ending dates for the period of
interest. For the life of me I cannot find away to display the final InvLvl
in my TransactionDate footer. In an attempt to discover the problem I put
the InvLvl in the Details section of the report and found when I set the
control source of a text box to InvLvl in the TransactionDate footer, it was
returning the first value returned by the query for the correct property
number, but it is undesirable when there are multiple transactions in the
date range. DLast returns the last value for all property numbers. I tried
to use variations on the following expression:
DLookup("[InvLvl]","qryInventory",DMax("[TransactionDate]","qryTransPropNum","[PropertyNumber]=[PropertyNumber]))
But to no avail. That particular version generated "#Error". Anyone have
any suggestions? Thanks in advance.