troubleshooting Question

include the Word "All" in a combo and have it displayed at top of Combo

Avatar of Karen Schaefer
Karen SchaeferFlag for United States of America asked on
Microsoft AccessSQL
21 Comments1 Solution279 ViewsLast Modified:
Help with displaying "All" at the top of list on a combo, but then have the rest of the list in ascending order by Program Title.

What am I missing?

SELECT tblPrograms.ProgramRecID, tblPrograms.[Program Title], tblPrograms.[Program Type]
FROM tblPrograms
GROUP BY tblPrograms.ProgramRecID, tblPrograms.[Program Title], tblPrograms.[Program Type]

union

SELECT "0" as ProgramRecID, "ALL" as [Program Title],"ALL" as [Program Type] FROM tblPrograms 

order by ProgramRecID, [Program Title]

K
ASKER CERTIFIED SOLUTION
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Database Architect / Application Developer
Join our community to see this answer!
Unlock 1 Answer and 21 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 21 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros