Hello,
I'm trying to create a query for a drop-down list. The selection in the drop-down is used to filter a report or form, and I'd like to have a wildcard value, "(All)", included in the list.
I can do that much; my SQL looks like
However, the result is not sorted in any human-intelligable fashion. What I'd really like to do is take two additional fields, [Table Employee List].LastName and [Table Employee List].FirstName, and sort the list by [LastName], then [FirstName], with "(All)" appearing at the top of the list.
Thank you for your help,
Tom
I'm trying to create a query for a drop-down list. The selection in the drop-down is used to filter a report or form, and I'd like to have a wildcard value, "(All)", included in the list.
I can do that much; my SQL looks like
Code:
SELECT [Table Employee List].FullName FROM [Table Employee List] UNION SELECT "(All)" FROM [Table Employee List];
However, the result is not sorted in any human-intelligable fashion. What I'd really like to do is take two additional fields, [Table Employee List].LastName and [Table Employee List].FirstName, and sort the list by [LastName], then [FirstName], with "(All)" appearing at the top of the list.
Thank you for your help,
Tom