Connecting 2 queries to a report?

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
 
L

Larry Linson

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
total groups in query 3
Summary Report 2
The time it takes to populate a report 1
grouping error? 8
List box - Find records to show in reports 8
Report to calculate total spent by customers in a customer db 8
Subtotal for a record 8

Top