Using the Count function

G

Guest

Please help me!!!!, I have a form which has questions with the replies as
either Yes or No Now I have to provide stats on the number of Yes's and the
number of No's.
Thanks.
 
D

Duane Hookom

Are we supposed to guess your table structure? A WAG assuming you have a
field named [Q1] that is a yes/no type field, you can create columns in a
query with expressions like:

Field: Q1YesCount: Abs([Q1])
Totals: Sum

Field: Q1NoCount: [Q1]+1
Totals: Sum
 
G

Guest

Sorry!!!!!
The field is " Is this your first Visit?" and they have the option from a
dropdown to select either " Yes" OR "No". So for eg. for this question I need
to know how many said yes and how many said no, there are about 400(records)
people surveyed.
Thanks

Duane Hookom said:
Are we supposed to guess your table structure? A WAG assuming you have a
field named [Q1] that is a yes/no type field, you can create columns in a
query with expressions like:

Field: Q1YesCount: Abs([Q1])
Totals: Sum

Field: Q1NoCount: [Q1]+1
Totals: Sum

--
Duane Hookom
MS Access MVP
--

FC said:
Please help me!!!!, I have a form which has questions with the replies as
either Yes or No Now I have to provide stats on the number of Yes's and
the
number of No's.
Thanks.
 
D

Duane Hookom

I see you started a new thread with the same question...

--
Duane Hookom
MS Access MVP


FC said:
Sorry!!!!!
The field is " Is this your first Visit?" and they have the option from a
dropdown to select either " Yes" OR "No". So for eg. for this question I
need
to know how many said yes and how many said no, there are about
400(records)
people surveyed.
Thanks

Duane Hookom said:
Are we supposed to guess your table structure? A WAG assuming you have a
field named [Q1] that is a yes/no type field, you can create columns in a
query with expressions like:

Field: Q1YesCount: Abs([Q1])
Totals: Sum

Field: Q1NoCount: [Q1]+1
Totals: Sum

--
Duane Hookom
MS Access MVP
--

FC said:
Please help me!!!!, I have a form which has questions with the replies
as
either Yes or No Now I have to provide stats on the number of Yes's and
the
number of No's.
Thanks.
 

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


Top