By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,270 Members | 1,582 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,270 IT Pros & Developers. It's quick & easy.

List plus "Unknown" in Combo Box

P: n/a
I need to create combo box that lists unique values from a table and
limit the selection to this list. However, I also need to add
"UNKNOWN" as a valid selection even though it is not in the table I am
using as the source for the combo box. Can this be done?

Thanks!
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a

Examples follow:-

SELECT 'Unknown' AS Expr1
From Table1
UNION
SELECT Table1.a
FROM Table1;

If you want to force it to the top

SELECT 'Unknown' AS Expr1, 0 AS seq
From Table1
UNION
SELECT Table1.a, 1 AS [seq]
FROM Table1
ORDER BY [seq];

Terry
"imw8n4u" <rx*****@qwest.com> wrote in message
news:7e**************************@posting.google.c om...
I need to create combo box that lists unique values from a table and
limit the selection to this list. However, I also need to add
"UNKNOWN" as a valid selection even though it is not in the table I am
using as the source for the combo box. Can this be done?

Thanks!

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.