How to add a text line to a query field (1 Viewer)

[lws]

I have a combo box that gathers data based on a query. Is it possible to add a line of text to be displaed every time i pull down the box?

For example I have:

Data1
Data2
Data3

I would like to have:

Not In List (the added txt)
Data1
Data2
Data3

 

[jdraw]

Yes.

You can use a Union query to do that.

Air code to show concept

SELECT  "Not In List (the added txt)" As AText 
 FROM Table1 
 UNION SELECT  Table1.AText 
 FROM Table1;

 

[lws]

I thought I would have to do somthing along that line. However I did not know if there was a insert cammand/code of some sort.

Thanks