Summary and Details need to combined in a query

G

g

Hi again access experts;
I'm having a problem again and hopefully someone out there can give me a
solution. Here are the details:

I have two queries, 1 is getting the total number of call in a unit and the
other query is the whole details and they both from the same source Table1:

Table1
Site Unit Calls
1 A3 1
1 A3 1
1 B1 1
1 C2 1
2 E6 1
3 A3 1

'Qry1 and Qry2 have a parameter of what site (Like [Site]) could be 1 or
other site number and on this sample I selected site 1.

Qry1
Site Unit Calls
1 A3 2
1 B1 1
1 C2 1

Qry2
Site Unit Calls
1 A3 1
1 A3 1
1 B1 1
1 C2 1

This is the result I wanted by combining them together in one query:

Qry3
Qry2.Unit Qry2.Calls Qry1.Unit Qry1.Calls
A3 1 A3 2
A3 1 B1 1
B1 1 C2 1
C2 1

I'm thinking if I could add a running number expression on both query I can
join them both together and I don't know how to accomplish that. The reason
why I need to this because in my report I have to show both a detailed
information and summary in the same line.
If you guys have a better solution to accomplish my problem that would be
nice.

Thank you
 

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

Top