Novice needing help on Counts

[EAGER BEAVER]

Hi I'm hoping someone can help.

I have entered in a survey of about 60 questions. Responses can be either
yes, no, unknown or other for each question. With the exception of the first
question, which responses can be nursing, clerical, multiple or other. I
need to do a basic count for each question. Ie. Count the number of nurses
who responded, Count the total number of clerks who responded. Then for the
2nd question count total number of yes's, total number of no's, total number
of unknown ect.. ect.

If you could help I would appreciate it.
Thanks.

 

[Jackie L]

You could use Totals queries. Create a query with criteria, for instance,
the criteria for the first field would be "nurse". Then create an expression
field for the question you wish to count similar to:
Answer2: IIF([Question2]="yes",1,0)

Since you are using a text field instead of a yes/no, you would need to give
the value you wish to count a 1 (Otherwise, yes/no answers already have a
value).

After you see the data you are looking for in the select query, then change
the query to a Total query. The total value for question one would be Where
and question2, Count.

Hope this helps.

 

[EAGER BEAVER]

Jackie Thanks for responding I really appreciate it,

As far as the Query goes, I have in the first column
Field: Question 1
Table: (The name of my table where data is stored)
Sort: should I select group by in order to get each response grouped ie.
Nurses, clerks etc.
Criteria: "nurse"

In the second column
Field: Question 2
Table: (The name of my table where data is stored)
Sort: Blank
Criteria:IIf([Question2]="yes",1,0)

Im not having much luck--

You could use Totals queries. Create a query with criteria, for instance,
the criteria for the first field would be "nurse". Then create an expression
field for the question you wish to count similar to:
Answer2: IIF([Question2]="yes",1,0)

Since you are using a text field instead of a yes/no, you would need to give
the value you wish to count a 1 (Otherwise, yes/no answers already have a
value).

After you see the data you are looking for in the select query, then change
the query to a Total query. The total value for question one would be Where
and question2, Count.

Hope this helps.

Hi I'm hoping someone can help.

I have entered in a survey of about 60 questions. Responses can be either
yes, no, unknown or other for each question. With the exception of the first
question, which responses can be nursing, clerical, multiple or other. I
need to do a basic count for each question. Ie. Count the number of nurses
who responded, Count the total number of clerks who responded. Then for the
2nd question count total number of yes's, total number of no's, total number
of unknown ect.. ect.

If you could help I would appreciate it.
Thanks.

 

[Jackie L]

E.B.
You need to have the field in your query to be
Answer2: IIF([Question2]="yes",1,0)

not the criteria.
In your example you say Field:Question2 - that instead should be like my
example above with no criteria.

Give that a try. Let me know if you need further explanation.

Jackie Thanks for responding I really appreciate it,

As far as the Query goes, I have in the first column
Field: Question 1
Table: (The name of my table where data is stored)
Sort: should I select group by in order to get each response grouped ie.
Nurses, clerks etc.
Criteria: "nurse"

In the second column
Field: Question 2
Table: (The name of my table where data is stored)
Sort: Blank
Criteria:IIf([Question2]="yes",1,0)

Im not having much luck--

You could use Totals queries. Create a query with criteria, for instance,
the criteria for the first field would be "nurse". Then create an expression
field for the question you wish to count similar to:
Answer2: IIF([Question2]="yes",1,0)

Since you are using a text field instead of a yes/no, you would need to give
the value you wish to count a 1 (Otherwise, yes/no answers already have a
value).

After you see the data you are looking for in the select query, then change
the query to a Total query. The total value for question one would be Where
and question2, Count.

Hope this helps.

Hi I'm hoping someone can help.

I have entered in a survey of about 60 questions. Responses can be either
yes, no, unknown or other for each question. With the exception of the first
question, which responses can be nursing, clerical, multiple or other. I
need to do a basic count for each question. Ie. Count the number of nurses
who responded, Count the total number of clerks who responded. Then for the
2nd question count total number of yes's, total number of no's, total number
of unknown ect.. ect.

If you could help I would appreciate it.
Thanks.

 

[EAGER BEAVER]

Thanks for your patience Jackie,

The field has a drop down menu of columns that I can select, do I need to
create a new field and label it Answer?- don't I put the expression
IIF([Question2]="yes",1,0)
in the criteria?

E.B.
You need to have the field in your query to be
Answer2: IIF([Question2]="yes",1,0)

not the criteria.
In your example you say Field:Question2 - that instead should be like my
example above with no criteria.

Give that a try. Let me know if you need further explanation.

Jackie Thanks for responding I really appreciate it,

As far as the Query goes, I have in the first column
Field: Question 1
Table: (The name of my table where data is stored)
Sort: should I select group by in order to get each response grouped ie.
Nurses, clerks etc.
Criteria: "nurse"

In the second column
Field: Question 2
Table: (The name of my table where data is stored)
Sort: Blank
Criteria:IIf([Question2]="yes",1,0)

Im not having much luck--

You could use Totals queries. Create a query with criteria, for instance,
the criteria for the first field would be "nurse". Then create an expression
field for the question you wish to count similar to:
Answer2: IIF([Question2]="yes",1,0)

Since you are using a text field instead of a yes/no, you would need to give
the value you wish to count a 1 (Otherwise, yes/no answers already have a
value).

After you see the data you are looking for in the select query, then change
the query to a Total query. The total value for question one would be Where
and question2, Count.

Hope this helps.

:

Hi I'm hoping someone can help.

I have entered in a survey of about 60 questions. Responses can be either
yes, no, unknown or other for each question. With the exception of the first
question, which responses can be nursing, clerical, multiple or other. I
need to do a basic count for each question. Ie. Count the number of nurses
who responded, Count the total number of clerks who responded. Then for the
2nd question count total number of yes's, total number of no's, total number
of unknown ect.. ect.

If you could help I would appreciate it.
Thanks.

 

[Jackie L]

Correct,
You would create a new field. If you put it in just like the example you
will then have a field called Answer2 with the value of 1 or 0. There would
be nothing in the criteria. Putting a Sum on that field will then total all
the 1's, giving you your count (I think I previously told you to make it a
Count field, what you need on the new field is a SUM).

I would be happy to send you an example if you need it.

Thanks for your patience Jackie,

The field has a drop down menu of columns that I can select, do I need to
create a new field and label it Answer?- don't I put the expression
IIF([Question2]="yes",1,0)
in the criteria?

E.B.
You need to have the field in your query to be
Answer2: IIF([Question2]="yes",1,0)

not the criteria.
In your example you say Field:Question2 - that instead should be like my
example above with no criteria.

Give that a try. Let me know if you need further explanation.

Jackie Thanks for responding I really appreciate it,

As far as the Query goes, I have in the first column
Field: Question 1
Table: (The name of my table where data is stored)
Sort: should I select group by in order to get each response grouped ie.
Nurses, clerks etc.
Criteria: "nurse"

In the second column
Field: Question 2
Table: (The name of my table where data is stored)
Sort: Blank
Criteria:IIf([Question2]="yes",1,0)

Im not having much luck--


:

You could use Totals queries. Create a query with criteria, for instance,
the criteria for the first field would be "nurse". Then create an expression
field for the question you wish to count similar to:
Answer2: IIF([Question2]="yes",1,0)

Since you are using a text field instead of a yes/no, you would need to give
the value you wish to count a 1 (Otherwise, yes/no answers already have a
value).

After you see the data you are looking for in the select query, then change
the query to a Total query. The total value for question one would be Where
and question2, Count.

Hope this helps.

:

Hi I'm hoping someone can help.

I have entered in a survey of about 60 questions. Responses can be either
yes, no, unknown or other for each question. With the exception of the first
question, which responses can be nursing, clerical, multiple or other. I
need to do a basic count for each question. Ie. Count the number of nurses
who responded, Count the total number of clerks who responded. Then for the
2nd question count total number of yes's, total number of no's, total number
of unknown ect.. ect.

If you could help I would appreciate it.
Thanks.

 

[EAGER BEAVER]

Jackie,
Your wonderful! Thanks for sticking with my questions, I really appreciate
it. If you could send me an example that would be wonderful. Is there
another way to do this without creating a query? Maybe go into report, under
detail create a text box then do a =Sum(IIf([Question 1]= Nursing,1,0))? I
would create a text box for each response?
If I was to do it this way the problem I am having is an automatic response
asking for the parameter- I'm guessing this is why a query would be better.
I'll add a new field and do as you suggested but won't I have to create a new
feild for each response?

Thanks agian, I thought you were fed up with my simple mind!

Correct,
You would create a new field. If you put it in just like the example you
will then have a field called Answer2 with the value of 1 or 0. There would
be nothing in the criteria. Putting a Sum on that field will then total all
the 1's, giving you your count (I think I previously told you to make it a
Count field, what you need on the new field is a SUM).

I would be happy to send you an example if you need it.

Thanks for your patience Jackie,

The field has a drop down menu of columns that I can select, do I need to
create a new field and label it Answer?- don't I put the expression
IIF([Question2]="yes",1,0)
in the criteria?

E.B.
You need to have the field in your query to be
Answer2: IIF([Question2]="yes",1,0)

not the criteria.
In your example you say Field:Question2 - that instead should be like my
example above with no criteria.

Give that a try. Let me know if you need further explanation.

:

Jackie Thanks for responding I really appreciate it,

As far as the Query goes, I have in the first column
Field: Question 1
Table: (The name of my table where data is stored)
Sort: should I select group by in order to get each response grouped ie.
Nurses, clerks etc.
Criteria: "nurse"

In the second column
Field: Question 2
Table: (The name of my table where data is stored)
Sort: Blank
Criteria:IIf([Question2]="yes",1,0)

Im not having much luck--


:

You could use Totals queries. Create a query with criteria, for instance,
the criteria for the first field would be "nurse". Then create an expression
field for the question you wish to count similar to:
Answer2: IIF([Question2]="yes",1,0)

Since you are using a text field instead of a yes/no, you would need to give
the value you wish to count a 1 (Otherwise, yes/no answers already have a
value).

After you see the data you are looking for in the select query, then change
the query to a Total query. The total value for question one would be Where
and question2, Count.

Hope this helps.

:

Hi I'm hoping someone can help.

I have entered in a survey of about 60 questions. Responses can be either
yes, no, unknown or other for each question. With the exception of the first
question, which responses can be nursing, clerical, multiple or other. I
need to do a basic count for each question. Ie. Count the number of nurses
who responded, Count the total number of clerks who responded. Then for the
2nd question count total number of yes's, total number of no's, total number
of unknown ect.. ect.

If you could help I would appreciate it.
Thanks.

 

[EAGER BEAVER]

Well Jackie,
I went into the table a created a new field called Answer 2. Then I open up
the query and basically copied and pasted the Answer2:
IIF([Question2]="yes",1,0)

I am getting all zero's regardless if the response was yes, no, other.

Correct,
You would create a new field. If you put it in just like the example you
will then have a field called Answer2 with the value of 1 or 0. There would
be nothing in the criteria. Putting a Sum on that field will then total all
the 1's, giving you your count (I think I previously told you to make it a
Count field, what you need on the new field is a SUM).

I would be happy to send you an example if you need it.

Thanks for your patience Jackie,

The field has a drop down menu of columns that I can select, do I need to
create a new field and label it Answer?- don't I put the expression
IIF([Question2]="yes",1,0)
in the criteria?

E.B.
You need to have the field in your query to be
Answer2: IIF([Question2]="yes",1,0)

not the criteria.
In your example you say Field:Question2 - that instead should be like my
example above with no criteria.

Give that a try. Let me know if you need further explanation.

:

Jackie Thanks for responding I really appreciate it,

As far as the Query goes, I have in the first column
Field: Question 1
Table: (The name of my table where data is stored)
Sort: should I select group by in order to get each response grouped ie.
Nurses, clerks etc.
Criteria: "nurse"

In the second column
Field: Question 2
Table: (The name of my table where data is stored)
Sort: Blank
Criteria:IIf([Question2]="yes",1,0)

Im not having much luck--


:

You could use Totals queries. Create a query with criteria, for instance,
the criteria for the first field would be "nurse". Then create an expression
field for the question you wish to count similar to:
Answer2: IIF([Question2]="yes",1,0)

Since you are using a text field instead of a yes/no, you would need to give
the value you wish to count a 1 (Otherwise, yes/no answers already have a
value).

After you see the data you are looking for in the select query, then change
the query to a Total query. The total value for question one would be Where
and question2, Count.

Hope this helps.

:

Hi I'm hoping someone can help.

I have entered in a survey of about 60 questions. Responses can be either
yes, no, unknown or other for each question. With the exception of the first
question, which responses can be nursing, clerical, multiple or other. I
need to do a basic count for each question. Ie. Count the number of nurses
who responded, Count the total number of clerks who responded. Then for the
2nd question count total number of yes's, total number of no's, total number
of unknown ect.. ect.

If you could help I would appreciate it.
Thanks.

 

[Jackie L]

Sorry if I was not clear. You do not need a new field in the table, you only
need to add the new field in the query. By putting a field name (Answer2)
followed by a : and the expression, you create a field that only exists in
the query.

Answer2: IIF([Question2]="yes",1,0)

Please let me know where you need the sample sent (be sure to add extra
removable characters as to avoid having your address "reused").

P.S. I only work part time so if I do not respond again today, it's because
I am off tomorrow.

Well Jackie,
I went into the table a created a new field called Answer 2. Then I open up
the query and basically copied and pasted the Answer2:
IIF([Question2]="yes",1,0)

I am getting all zero's regardless if the response was yes, no, other.

Correct,
You would create a new field. If you put it in just like the example you
will then have a field called Answer2 with the value of 1 or 0. There would
be nothing in the criteria. Putting a Sum on that field will then total all
the 1's, giving you your count (I think I previously told you to make it a
Count field, what you need on the new field is a SUM).

I would be happy to send you an example if you need it.

Thanks for your patience Jackie,

The field has a drop down menu of columns that I can select, do I need to
create a new field and label it Answer?- don't I put the expression
IIF([Question2]="yes",1,0)
in the criteria?



:

E.B.
You need to have the field in your query to be
Answer2: IIF([Question2]="yes",1,0)

not the criteria.
In your example you say Field:Question2 - that instead should be like my
example above with no criteria.

Give that a try. Let me know if you need further explanation.

:

Jackie Thanks for responding I really appreciate it,

As far as the Query goes, I have in the first column
Field: Question 1
Table: (The name of my table where data is stored)
Sort: should I select group by in order to get each response grouped ie.
Nurses, clerks etc.
Criteria: "nurse"

In the second column
Field: Question 2
Table: (The name of my table where data is stored)
Sort: Blank
Criteria:IIf([Question2]="yes",1,0)

Im not having much luck--


:

You could use Totals queries. Create a query with criteria, for instance,
the criteria for the first field would be "nurse". Then create an expression
field for the question you wish to count similar to:
Answer2: IIF([Question2]="yes",1,0)

Since you are using a text field instead of a yes/no, you would need to give
the value you wish to count a 1 (Otherwise, yes/no answers already have a
value).

After you see the data you are looking for in the select query, then change
the query to a Total query. The total value for question one would be Where
and question2, Count.

Hope this helps.

:

Hi I'm hoping someone can help.

I have entered in a survey of about 60 questions. Responses can be either
yes, no, unknown or other for each question. With the exception of the first
question, which responses can be nursing, clerical, multiple or other. I
need to do a basic count for each question. Ie. Count the number of nurses
who responded, Count the total number of clerks who responded. Then for the
2nd question count total number of yes's, total number of no's, total number
of unknown ect.. ect.

If you could help I would appreciate it.
Thanks.