Adding an Item to a Query Result

  • Thread starter Thread starter Chaplain Doug
  • Start date Start date
C

Chaplain Doug

I am setting the row source of a combo control to the
values contained in a table. I wish to add one item to
the row source without modifying the table. My SQL for
the row source is:

SELECT [Units Query].UnitTitle FROM [Units Query];

I want to add the selection "All" to the top of the list
produced by the row source. How may I do that?
 
SELECT "<ALL>" FROM [Units Query]
UNION
SELECT [Units Query].UnitTitle
FROM [Units Query];


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Back
Top