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.
 
You must log in or register to reply here.

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

Similar Threads

Totalling yes or No's 3
Totalling Yes or No Answers 2
Prefilled Outlook Yes Voting Button response 0
Yes/No parameter for selecting either 3
Yes / No query problem 4
Yes / Yes + N Responses for percentage 4
Yes responses divided by yes + No responses for percentage 14
Yes/No parameter for Yes or No or Both 7

Back
Top