I have a report that is pulling data from a query. The query gets sent a parameter from a form. The information on the form is correct, but my summary section is incorrect.
The reason the summary is incorrect is because of the expression used to summarize. I'm using DLookup to find totals in a separate query.
Here's an example of my DLookup now:
Expand|Select|Wrap|Line Numbers
- =DLookUp("CountOfStartingLocation","qryDestinationTotal","StartingLocation='Admissions'")
I've added Program to the list of fields in the query and it works if I run the query...now I just need to get the summary fields to coincide.
Thanks for the help,
beacon