Getting Totals In A Report From An Outside Query

S

stillcrazee

Have a report footer total that I need filled, but can't do it from the query
I based the report on.

I created another query with a field that has the numbers I need, but I
don't know how to get numbers (or a total of the field preferrably), from a
query that is not the one referenced when I created the report.
 
F

fredg

Have a report footer total that I need filled, but can't do it from the query
I based the report on.

I created another query with a field that has the numbers I need, but I
don't know how to get numbers (or a total of the field preferrably), from a
query that is not the one referenced when I created the report.
Click to expand...

Are you sure you can't do this all within the report?

If the query returns just the one total...
In an unbound control on the report:
=DLookUp("[ColumnName]","QueryName")
 
Top