View Full Version : adding an "ALL" to the listbox


charityg
07-10-2001, 12:48 PM
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

charityg
07-10-2001, 01:11 PM
Nevermind.