4 Query's in one report
I have a Report graph that is based on 4 querys. These 4 querys prompt the user for the same 3 questions Name, Start Date & End Date. The criteria for the Name field is
Like "*" & [Enter Partial Name] & "*"
and the criteria for the start/end date is
>=[Start Date:] And <=[End Date:].
I was wondering when the user enters the Name, Start&End dates can these answers replicate to the other 3 querys so they don't have to enter the samething 4 times.
Or do anyone know another way around this?
Thanks for any help
Chris
I have a Report graph that is based on 4 querys. These 4 querys prompt the user for the same 3 questions Name, Start Date & End Date. The criteria for the Name field is
Like "*" & [Enter Partial Name] & "*"
and the criteria for the start/end date is
>=[Start Date:] And <=[End Date:].
I was wondering when the user enters the Name, Start&End dates can these answers replicate to the other 3 querys so they don't have to enter the samething 4 times.
Or do anyone know another way around this?
Thanks for any help
Chris