Union Query

[Seaman]

Hi,

I have a table with 1 column and 1 value "<<All>>". The
name of the column is P_VER.

Then I made a query named "version" which fills a
dropdownlist1 depending on what was selected from another
dropdownlist2.

Now I want dropdownlist1 to have <<All>> added.

Can someone give me the code for the UNION Query please ?

Thanks

 

[Wayne Morgan]

You will find an example of what you're trying to do here.

http://www.mvps.org/access/forms/frm0043.htm

The example assumes more than one column and assigns Null to the 2nd column
associated with All then sorts on that 2nd column. Since Null will be at the
top of the sort, it puts All at the top. If you're using a single column
then the << in front of All should do the same thing when you sort your
single column.