Combo box values mixture of table and values?

[gpeirce]

I have a need to produce a report based on a combo box of Nurse's names. However, I also want to be able to produce the same report for every Nurse.

Is there a way to populate the combo box with a table of names PLUS the value field with the word "All"? My form VBA can figure out what to do with the "all" once it's invoked.

Thank you!

 

[gpeirce]

Thank you, Uncle. It occurred to me today that a union would do the trick.

That's a nice offer to post Youtube videos of solutions. I may take you up on that. I'm an OLD mainframe programmer that did just about any kind of program in SQL. Transferring to Access has been quite a jolt!