Combo Box Source + "All"

[Ryan Langton]

I have a combo box that lists table values (a list of employees). I want
the combo box to allow selection of any of these individual employees as
well as an option for "ALL". However, since the drop down box queries the
Employee table, and there is no employee named "ALL", "ALL" is not a viable
selection. Is there any way to do this besides adding an employee to the
employee table named "ALL"?

Thanks,
Ryan

 

[Douglas J. Steele]

Take a look at http://www.mvps.org/access/forms/frm0043.htm at "The Access
Web"

 

[aaron.kempf]

if you want a real answer to this; use Office Web Components and
Analysis Services.

This is the 'All' level on steroids

 

[Ryan Langton]

Just what I needed Doug, Thanks!

Take a look at http://www.mvps.org/access/forms/frm0043.htm at "The Access
Web"