Parameter Query Based on Form Input within a Union Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a union query, but want to base the results on what is entered
on a form. How would I go about doing that?

Thanks.

Jana
 
Use criteria in the individual parts of the union query referencing the form
text box like this ---
[Forms]![YourFormName]![TextBoxName]
 
That makes sense. Thanks for your assistance. I needed a night to sleep on
it.

KARL DEWEY said:
Use criteria in the individual parts of the union query referencing the form
text box like this ---
[Forms]![YourFormName]![TextBoxName]
--
KARL DEWEY
Build a little - Test a little


[email protected] said:
I have created a union query, but want to base the results on what is entered
on a form. How would I go about doing that?

Thanks.

Jana
Click to expand...
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Parameter Query Won't Run 0
union query sort 3
Run Make Table Query on Union Query 2
Union query 5
Union Query 2
MS 2003 Parameterized Query 0
Data displayed wrongly in Union query 6
Union Query Based on Two Crosstab Queries 4

Back
Top