A
alan_mitchell
Hi all,
I have a query which shows staff members and their campaigns. The 'criteria'
part of the query looks up the staff member selected in a report's list box
and filters for that staff member.
So for example, if the user selects 'Joe Bloggs' on the report' list box,
the query will filter to only show records that belong to Joe Bloggs'.
This works fine, but I want to be able to provide an option to NOT FILTER
any stff membersat all. So perhaps if the user ticks a check box 'show
campaigns for all staff', the query will show ALL records.
Any idea how to do this?
Thanks,
Alan
I have a query which shows staff members and their campaigns. The 'criteria'
part of the query looks up the staff member selected in a report's list box
and filters for that staff member.
So for example, if the user selects 'Joe Bloggs' on the report' list box,
the query will filter to only show records that belong to Joe Bloggs'.
This works fine, but I want to be able to provide an option to NOT FILTER
any stff membersat all. So perhaps if the user ticks a check box 'show
campaigns for all staff', the query will show ALL records.
Any idea how to do this?
Thanks,
Alan