Is there a way to add a record using SQL (Access, DAO) with 'fixed' values only ? I've searched but couldn't find anything (too much results with not even close to what I want)..

The reason is this, I'm using standard SQL queries to fill a combobox, but the specified table doesn't have a record with the needed selection (and it shouldn't).

So I'm looking into UNION and would figure something like this (which would propably work in MySQL):

Code:
SELECT "<No item>", 0
UNION
SELECT MyDescription,MyID FROM MyTable
ORDER BY MyDescription,MyID
Which would result in a recordset like so:
"<No item>",0
"MyItem1", 1
"MyItem2", 2
"MyItem3", 3

But it doesn't seem to work in Access..

Any idea how to do this in an SQL query which works with MSAccess?