?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.

Jenn wrote:

?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;

--

Dave Peterson