Jester00130
10-13-2004, 03:41 PM
Have an underlying query that uses a criteria date parameter meant to request begin and end dates on query use or when report is run. Unfortunately, when I run the report it asks me for the creteria [begin date] and [end date] twice. Any ideas as to why this might be happening? Any insights would be helpful. :o
Pat Hartman
10-13-2004, 10:02 PM
There are certain situations where Access needs to run the report's query more than once. If this happens, you are prompted each time the query runs. The solution most people adopt is to use a form to gather parameters and run the report from a button on the form. The criteria would then refer to form controls:
Where YourDate Between Forms!YourForm!FromDate AND Forms!YourForm!ThroghDate;