How to add a text line to a query field

lws

Registered User.
Local time
Yesterday, 23:44
Joined
Mar 14, 2013
Messages
22
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
 
Yes.

You can use a Union query to do that.

Air code to show concept

Code:
SELECT  "Not In List (the added txt)" As AText 
 FROM Table1 
 UNION SELECT  Table1.AText 
 FROM Table1;
 
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
 

Users who are viewing this thread

Back
Top Bottom