report totals

[cc]

In a database for parking garage leases, I have the following:

1. In combo box LOCATION - drop down choices "Garage A" and "Garage B"

2. In combo box ACCESS - drop down choices "24/7," "Night/Weekend,"
"Pool-24/7" and "Pool-Night/Weekend"

3. In combo box TYPE - drop down choices "Reserved" and "Non-Reserved"

I would like to have totals in the report that calculate the number of
leases that meet the following criteria, for example:

1. Garage A, 24/7, non-reserved

2. Garage A, Pool-24/7, Pool-Night/Weekend, non-reserved

I would greatly appreciate someone's help with this. THANK YOU in advance.

 

[Marshall Barton]

In a database for parking garage leases, I have the following:

1. In combo box LOCATION - drop down choices "Garage A" and "Garage B"

2. In combo box ACCESS - drop down choices "24/7," "Night/Weekend,"
"Pool-24/7" and "Pool-Night/Weekend"

3. In combo box TYPE - drop down choices "Reserved" and "Non-Reserved"

I would like to have totals in the report that calculate the number of
leases that meet the following criteria, for example:

1. Garage A, 24/7, non-reserved

2. Garage A, Pool-24/7, Pool-Night/Weekend, non-reserved

You should create a query that calculates the totals and use
that as the record source for a simple subreport. The query
might look like:

SELECT Location, Access, Type, Count(*) As NumLeases
FROM [your report record source query]
GROUP BY Location, Access, Type