Hello,
I want to be able to run a query based on the information that user or i enter.
There are currently 3 parameters, one is a date to date parameter.
The other two parameters come from slots in tables that have dropboxes.
I haven't got the chance to get to other two.
Now when i set parameter on date to date: Between [Start Date:] and [End Date:] the query does work. However if i want to create a form based on this query, so that people can enter the paremeters. The dropboxes appear themselves but before i can create a form based on it, when i select a query for the form, the damn pop up box comes up... and i can't move to designing the form.
On a form i want user/me enter start date end date, and on the the other row there are two drop box parameters...
So how do i accomplish that?
Later i will use this same query to generate reports as well.
thank you!
I want to be able to run a query based on the information that user or i enter.
There are currently 3 parameters, one is a date to date parameter.
The other two parameters come from slots in tables that have dropboxes.
I haven't got the chance to get to other two.
Now when i set parameter on date to date: Between [Start Date:] and [End Date:] the query does work. However if i want to create a form based on this query, so that people can enter the paremeters. The dropboxes appear themselves but before i can create a form based on it, when i select a query for the form, the damn pop up box comes up... and i can't move to designing the form.
On a form i want user/me enter start date end date, and on the the other row there are two drop box parameters...
So how do i accomplish that?
Later i will use this same query to generate reports as well.
thank you!
