DLookup in another report

[Guest]

I've never used DLookup so don't know how it can be used. Is it possible to
do a dlookup to get a value from another report? I have 3 separate reports
that shows a weekly avg shipment by UPC from the last 4wks, 12wks, and 24wks.
Would like to create one report that would list the UPC and then have the
4wk, 12wk, and 24wk average next to each other on that report.

My current reports is broken out by Division by using a Division Header so
each division may have the same UCPs listed if they ordered that same UPC in
that time frame so don't know if a DLookup would work anyway. If not, do you
have any suggestions on how I could create one report that would show all
three of these time frames together? I get the current Avg Shipments on each
report by creating a text box that takes the sum of all shipments and divides
by the number of weeks.

 

[Marshall Barton]

I've never used DLookup so don't know how it can be used. Is it possible to
do a dlookup to get a value from another report? I have 3 separate reports
that shows a weekly avg shipment by UPC from the last 4wks, 12wks, and 24wks.
Would like to create one report that would list the UPC and then have the
4wk, 12wk, and 24wk average next to each other on that report.

My current reports is broken out by Division by using a Division Header so
each division may have the same UCPs listed if they ordered that same UPC in
that time frame so don't know if a DLookup would work anyway. If not, do you
have any suggestions on how I could create one report that would show all
three of these time frames together? I get the current Avg Shipments on each
report by creating a text box that takes the sum of all shipments and divides
by the number of weeks.

No. DLookup is used to retrieve a single value from a
table.

You would be better off creating a query that presents the
desired data to the new report. You should use a Totals
type query to calculate the desired values. It might be
easiest to use three separate Totals queries, one for each
period and then a UNION query to pull them together for the
report.