Criteria sent to multiple query's

[jsloop]

I do not know if this is possible but I would like to have user entered
criteria sent to multiple Query's at the same time. What I have is several
Query's that look for something specific on what was purchased in different
catagories. They need all that info in one report, the common criteria
between them all (which the user will enter) is Customer number and dates.
Any idea's?


Thanks
JS

 

[Guest]

You could create a form where the user would enter the details required then
press a button which runs the querys / report. Just enter int he criteria for
each query the reference to the form.

for example for the customer number

In the criteria for customer number in each query enter something like

Forms!NameOfForm!CustomerID

NameOfForm = the name of the form you create

You would trhen need to do this for date as well

 

[jsloop]

Thank you, I will give that a try.

You could create a form where the user would enter the details required then
press a button which runs the querys / report. Just enter int he criteria for
each query the reference to the form.

for example for the customer number

In the criteria for customer number in each query enter something like

Forms!NameOfForm!CustomerID

NameOfForm = the name of the form you create

You would trhen need to do this for date as well

I do not know if this is possible but I would like to have user entered
criteria sent to multiple Query's at the same time. What I have is several

[quoted text clipped - 5 lines]

Thanks
JS