Using the Count function

[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.

 

[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

 

[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

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
--

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.

 

[Duane Hookom]

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

--
Duane Hookom
MS Access MVP

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

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
--

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.