More than 1 query on a report.

[Suze]

I've asked this question before and I've seen others ask
it but I've never
seen an answer that made sense to me. Not because the
response was wrong or
poorly written but because of my very limited experience
in Access. I'm
going to ask my question in a different way. If someone
could walk me
through this (click this, now type that, etc.) or post a
sample somewhere
I'd be very, very grateful.

Let's say I have a table that shows name and state of
customers.

Joe Smith TX
Bob Jones NY
Andy Kaufman NY
Mary Queen of Scots TN
Joe Doe NY
Joe Grant NY

I need a report that shows me

1.The total number of customers in New York
2. The total number of customers with the first name of
Joe

So it would look like this:
NY Customers: 4
Customers named Joe: 3

How do I do it? I'm currently using a query to give me a
listing of all
customers named Joe and another query to give me all
customers from NY. I
can't get both queries to show up on the same report. This
seems to me like
it woud be a basic feature of Access so I must be an
idiot. Please help!

 

[Duane Hookom]

If you can make one report based on one query and another report based on
another query, then create a third, blank report. While viewing the design
view of the third report, drag the two previous reports from the database
window onto the third report. Arrange the reports to meet your design/layout
needs.

Usually reports like this want a total for every state and a total for every
first name with multiple records in each.