Manually Add a record to a query.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Some where many years ago I saw away to add a record to an query.

The Ideal.
I have a query. It give a list of magazine codes. After the query runs I
would like to add a rercord: "NONE" to the query. That way when I look in
the list box the user can select "NONE". Is it also possible to make "NONE"
the first or last record?

This is just an ideal I was playing with.

Scott Burke
 
Hi,


Someone can use an UNION:


SELECT 'None' As name , 0 As prime FROM myTable
UNION
SELECT magazine, 1 FROM myTable
ORDER BY prime, name



Hoping it may help,
Vanderghast, Access MVP
 
Normally the way to do this is to use a UNION query

Select BookTitle
FROM Books
UNION
Select " None "
FROM Books
Order by BookTitle

Assuming that none of the book titles start with a space that will put None
(leading space) at the top of the list, followed by the other titles.
 
Back
Top