|
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
I am creating a report that has 3 columns of numeric data. The first column totals all the times a patient selected a "goal". The second column totals all the times the goal that was selected was achieved 75% or 100% of the time by the patient. The third column is the percentage of pts that achieved their goal 75-100% of the time. I am able to get the first column of data into the report by using a calculated field of "Count: Exercise Goals" in the query. On the Report, I need to Count the number of times that the field "Exercise Goals" = 75% or 100% of the time. (Instead of 0, 25% or 50%). On the Report, I can use a calculated expression to count all of the selections in the field using Count([Exercise Goals]), but how do I get it to count only the times it was answered as 75% or 100% ?
Can you do that with a calculated expression at the report level? I have a sample database to post, but how do I attach it??? Last edited by sdeepe : October 17th, 2003 at 05:48 AM. |
|
#2
|
|||
|
|||
|
It is easier to create a query, where you do all the calculations in before you throw it in to a report. There will be things you just can't do in the query because of the layout of the report, I would recommed doing as much of the calculations in query first before doing expressions on the report.
In your query create an if exxpression that says IIF( PercentageField >75 then,1,0) Then query this query again and Sum all the "1"'s that are showing, then pass this information to a report |
![]() |
| Viewing: ASP Free Forums > Database > Microsoft Access Help > Count Only Certain Responses |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|