Prev: Non-Recognition of a parameter
Next: Multiple Commas
From: Mr-Re Man on 12 Feb 2010 06:41
I have a query with 5 fields
[permit_type_txt], [age],[schoolsid_no],[sen_passenger],[schoolname_txt]

Permit Type has 3 values, either "Season Ticket, Standard Ticket & Concession"
There are approx 70 different schools

I need to create a report that counts how many season tickets, standard,
concession passes have been issued against each school.

Is this possible?
From: Allen Browne on 12 Feb 2010 06:57
1. In query design view, depress the Total button (upper sigma icon on the
toolbar/ribbon.) Access adds a Total row to the query design grid.

2. Add [permit_type_txt] and [schoolsid_no] to the query design grid.
In the Total row, accept Group By under both.

3. Add [schoolsid_no] again (i.e. in the next free column.)
This time, choose Count in the Total row.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


"Mr-Re Man" <MrReMan(a)discussions.microsoft.com> wrote in message
news:8F0C3326-6BB4-40BA-8543-B0C2B4946861(a)microsoft.com...
> I have a query with 5 fields
> [permit_type_txt], [age],[schoolsid_no],[sen_passenger],[schoolname_txt]
>
> Permit Type has 3 values, either "Season Ticket, Standard Ticket &
> Concession"
> There are approx 70 different schools
>
> I need to create a report that counts how many season tickets, standard,
> concession passes have been issued against each school.
>
> Is this possible?

 | 
Pages: 1
Prev: Non-Recognition of a parameter
Next: Multiple Commas