If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to count a value in a field
Access 2003
I am trying to run a query for a report. One of the fields I need to report on is an "Option" field with 3 options. How can I get a count of all of each Option? There are several other fields on in the query with criteria Thanks in advance, dave |
#2
|
|||
|
|||
How to count a value in a field
On Sun, 6 Jul 2008 14:36:38 -0700, dave wrote:
Access 2003 I am trying to run a query for a report. One of the fields I need to report on is an "Option" field with 3 options. How can I get a count of all of each Option? There are several other fields on in the query with criteria Thanks in advance, dave I would do this in the report itself. Use 3 unbound text controls placed anywhere in the report EXCEPT in the Page Header or Page Footer sections: =Sum(IIf([OptionName] = 1,1,0)) =Sum(IIf([OptionName] = 2,1,0)) =Sum(IIf([OptionName] = 3,1,0)) -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |
#3
|
|||
|
|||
How to count a value in a field
Thanks for the reply.
If I do it this way - how do I keep the option field from repeating for every record (I only need a total - not each record) dave "fredg" wrote in message . .. On Sun, 6 Jul 2008 14:36:38 -0700, dave wrote: Access 2003 I am trying to run a query for a report. One of the fields I need to report on is an "Option" field with 3 options. How can I get a count of all of each Option? There are several other fields on in the query with criteria Thanks in advance, dave I would do this in the report itself. Use 3 unbound text controls placed anywhere in the report EXCEPT in the Page Header or Page Footer sections: =Sum(IIf([OptionName] = 1,1,0)) =Sum(IIf([OptionName] = 2,1,0)) =Sum(IIf([OptionName] = 3,1,0)) -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |
#4
|
|||
|
|||
How to count a value in a field
On Jul 6, 6:37 pm, "dave" wrote:
Thanks for the reply. If I do it this way - how do I keep the option field from repeating for every record (I only need a total - not each record) dave "fredg" wrote in message . .. On Sun, 6 Jul 2008 14:36:38 -0700, dave wrote: Access 2003 I am trying to run a query for a report. One of the fields I need to report on is an "Option" field with 3 options. How can I get a count of all of each Option? There are several other fields on in the query with criteria Thanks in advance, dave I would do this in the report itself. Use 3 unbound text controls placed anywhere in the report EXCEPT in the Page Header or Page Footer sections: =Sum(IIf([OptionName] = 1,1,0)) =Sum(IIf([OptionName] = 2,1,0)) =Sum(IIf([OptionName] = 3,1,0)) -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail put it in a summary section - not in the detail section. |
#5
|
|||
|
|||
How to count a value in a field
On Sun, 6 Jul 2008 16:37:22 -0700, dave wrote:
Thanks for the reply. If I do it this way - how do I keep the option field from repeating for every record (I only need a total - not each record) dave "fredg" wrote in message . .. On Sun, 6 Jul 2008 14:36:38 -0700, dave wrote: Access 2003 I am trying to run a query for a report. One of the fields I need to report on is an "Option" field with 3 options. How can I get a count of all of each Option? There are several other fields on in the query with criteria Thanks in advance, dave I would do this in the report itself. Use 3 unbound text controls placed anywhere in the report EXCEPT in the Page Header or Page Footer sections: =Sum(IIf([OptionName] = 1,1,0)) =Sum(IIf([OptionName] = 2,1,0)) =Sum(IIf([OptionName] = 3,1,0)) -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail Did you try it in the Report Footer? -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |
Thread Tools | |
Display Modes | |
|
|