SQL problems

[mattalexx]

I have a combo box with the following ControlSource:

"SELECT DBAbbrev FROM tblDB ORDER BY DBAbbrev"

I lists all entries in DBAbbrev from tblDB. How do I make an SQL that lists the string "All" on the top? For example:

I have:

Sel1
Sel2
Sel3
Sel4
Sel5

I need:

All
Sel1
Sel2
Sel3
Sel4
Sel5

Is this possible?

Thanks in advance,
Matt(+)

[DerFarm]

You are selecting the entries from a table. You will only get the
entries in that table.

If you wish to add the explicit term "All", look into using a UNION
query. Essentially, you want the all the terms from the table and
then you would UNION this with a query that returns the single
item "All".

Try it out in Access first to get the syntax.


HTH