Adding blank space to lookup list

[BCote689]

I have a lookup list which yields something like this

****
City1
City2
City3
****

I want it to add a blank space to it, to look like this

****

City1
City2
City3
****

I tried add a union query to SQL statement generated by access like this..


SELECT "" UNION SELECT **THE STATEMENT GENERATED BY ACCESSS***

But that does not work.... Any thoughts?

I have used ROW SOURCE=VALUE LIST for the simple cases, but need to have ROW SOURCE=QUERY for some more complex cases.

 

[ajetrumpet]

Just add a record to the table from which you are querying. Make the record completely blank, or a Zero Length String, as we would call it...

 

[boblarson]

Actually, you can add a space by using a Union Query instead of a regular query.

So if you have City as a field and only one field in your query it would be like this:

Select City FROM YourTableName
UNION
Select NULL AS City FROM YourTableName;

 

[BCote689]

Good Job Bob...thanks very much!!!

 

[ajetrumpet]

thanks bob. i didn't know that either.