M
mromyn
Hi -
I have a Form, that executes a Report based on a Query.
I need to enter several parameters for the report:
Manager
Team
Department
Start Date
End Date
The first 3 are combo boxes. I have set the criteria in the query to
Forms![Run Report]!cboManager. However, it is not using the parameter for
Manager.
Can I have a From that calls a Report based on the Query? Or do the
parameters have to be called out in the Report?
For the Date fields I need to enter a date range and only use records
withing that range.
Also, for each parameter there needs to be a way to include all records if
it is left NULL.
Does anyone have an example of something like this?
Thanks,
Mel
I have a Form, that executes a Report based on a Query.
I need to enter several parameters for the report:
Manager
Team
Department
Start Date
End Date
The first 3 are combo boxes. I have set the criteria in the query to
Forms![Run Report]!cboManager. However, it is not using the parameter for
Manager.
Can I have a From that calls a Report based on the Query? Or do the
parameters have to be called out in the Report?
For the Date fields I need to enter a date range and only use records
withing that range.
Also, for each parameter there needs to be a way to include all records if
it is left NULL.
Does anyone have an example of something like this?
Thanks,
Mel