G
Guest
I have a form that includes a subform. The main form uses a collection of
data from the subform to create some calculations and formulations. The form
and subform work great. I made a report using the main form as the sourse
because it makes calculations from the subform that a query couldn't. Like
it takes the last date listed for a student in the subform, and the last
class a student took listed in the subform and listed that last date and last
class in the report. My problem is, once students have passed a certain
class, I don't want them listed in the report any longer. So once they have
passed class 7, I want to filter them from the report results. I still want
their overall progress listed in the form.... just filtered from this
particular report. Since the report is based on form data, I don't know how
to do this. In the past, I've only filtered data using an underlying query
or table. I tried to make a query based on the subform table, but couldn't
get it to find the last date and last class taken for each student.
Can anyone tell me how to filter data from a report that is based on data
from a form?
Thanks!
Kass
data from the subform to create some calculations and formulations. The form
and subform work great. I made a report using the main form as the sourse
because it makes calculations from the subform that a query couldn't. Like
it takes the last date listed for a student in the subform, and the last
class a student took listed in the subform and listed that last date and last
class in the report. My problem is, once students have passed a certain
class, I don't want them listed in the report any longer. So once they have
passed class 7, I want to filter them from the report results. I still want
their overall progress listed in the form.... just filtered from this
particular report. Since the report is based on form data, I don't know how
to do this. In the past, I've only filtered data using an underlying query
or table. I tried to make a query based on the subform table, but couldn't
get it to find the last date and last class taken for each student.
Can anyone tell me how to filter data from a report that is based on data
from a form?
Thanks!
Kass