adding an "ALL" to the listbox

charityg

Registered User.
Local time
Today, 21:49
Joined
Apr 17, 2001
Messages
634
Okay, I know this is an easy one, and I've looked for the answer EVERYWHERE!

I want to use a union query as the rowsource for a listbox, so that I can have a row that displays "ALL" before the rest of the queried list. What's my SQL statement look like?

It's been a long day and I think I've earned the right to ask an easy question without losing all of my hair trying to find the solution on my own.

Thanks guys!
~Charity
 

Users who are viewing this thread

Back
Top Bottom