Totslling Yes or No

  • Thread starter Thread starter belczyk
  • Start date Start date
B

belczyk

Can someone email me a small sample database that reflects a yes or
no
answer to a group. like if i want to know how many 35, 36, 40 yr
olds
are married, which is answered by a yes or no.

Can some one help


Please


Email (e-mail address removed)
 
So you have a table with fields such as these:
PersonID AutoNumber primary key
Surname Text
FirstName Text
Age Number
IsMarried Yes/No

1. Create a quey using this table.

2. Depress the Total button on the toolbar.
Access adds a Total row to the grid.

3. Drag the Age field into the grid.
In the Total row, accept Group By under this field.

4. Drag the IsMarried field into the grid.
Accept Group By under this field as well.

5. Drag the primary key field into the grid.
In the Total row under this field, choose Count.
 
Back
Top