Help w/ Union Queries

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

Guest

?Can anyone tell me how to make a Union Query. I am not very advanced in
Access. I need to make a combo box that allows the user to select all or
just one item. The response back suggested I make a union query to do this.

Currently my combo box row source is from a table called "Project".
The response from the community told me to do the following but I am lost.
Thanks in advance for your help!

Response:
Use a Union query as the row source for your combo box:

Select "All"
From SomeTable
UNION
Select SomeField
From SomeTable;
 
There are lots of people who use access that frequent these Excel newsgroups.

But if you don't get an answer, you may want to post in an Access newsgroup.
 
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

Import New Database Query (Union Query) in Spreadsheet 2
ComboBox RowSource UnionQuery 1
Union Query Where Clause 0
Insert row on multiple sheets 6
Union Query 1
Duplicates in union query 3
Union Query 2
loop thru records to create a union query 7

Back
Top