Connecting 2 queries to a report?

  • Thread starter Thread starter scott
  • Start date Start date
S

scott

I have 2 queries..one has a bunch of fields about
customers.

The 2nd query has the total that that all the customers
have spent.

How do I get both in a record? I want it to look something
like this.

scott NY $10
gary AL $25
Total $35
 
Why don't you just use the Sum function in the Report or Group Footer?
That'll give you the total, added up from the individual records.

If there's some reason that you can't use the Sum function, then take a look
at the DSUM function and use it as the Control Source of a Calculated Field.

The suggestion of UNION or UNION ALLing two queries will only work if there
are corresponding fields of the same type (not necessarily the same field
name) in the queries/tables that you are UNIONing.

Larry Linson
Microsoft Access MVP
 
Back
Top