R
rebecky via AccessMonster.com
Hello. I have a report for statistical purposes. I have calculating text
boxes to provide the numbers. The numbers are based upon student
participation within an activity by a specified time period. So in the query,
I have a field called [End] and the criteria is Between[Type a beginning date]
and[Type an Ending Date] or IsNull. The purpose to show all active students
in each activity as well as those who ended that activity within the
specified time period.
I now want to break down the participations by Month within a separate table
of this same report. So for example:
In July of 2008, there were 8 folks who ended GED(Regardless of when they
started)and there was 1 who started in June and to this day has not ended.
So I want a text box to count all the students who were in GED in July 2008
(9) .
I tried converting the [end] date to the month number ([expr3]) and that
works to count the ones who ended that month but I can't figure out how to
pick up the one who was still active and had started in June.
=Sum(IIf(IsNull([End]) And [ACTIVITY]="GED" And [start]<[expr3] Or Not IsNull
([End]),[expr3]=7,0))
I am sure I am going about this completely wrong and there is a simple
solution.....Can anyone help?\
Thanks in Advance!!!
boxes to provide the numbers. The numbers are based upon student
participation within an activity by a specified time period. So in the query,
I have a field called [End] and the criteria is Between[Type a beginning date]
and[Type an Ending Date] or IsNull. The purpose to show all active students
in each activity as well as those who ended that activity within the
specified time period.
I now want to break down the participations by Month within a separate table
of this same report. So for example:
In July of 2008, there were 8 folks who ended GED(Regardless of when they
started)and there was 1 who started in June and to this day has not ended.
So I want a text box to count all the students who were in GED in July 2008
(9) .
I tried converting the [end] date to the month number ([expr3]) and that
works to count the ones who ended that month but I can't figure out how to
pick up the one who was still active and had started in June.
=Sum(IIf(IsNull([End]) And [ACTIVITY]="GED" And [start]<[expr3] Or Not IsNull
([End]),[expr3]=7,0))
I am sure I am going about this completely wrong and there is a simple
solution.....Can anyone help?\
Thanks in Advance!!!