Making an "All" option for a combo box that affect the outcome of the query

[beanhead0321]

Hey Guys,



I'm having trouble figuring out a way to put an "All" option in a combo box so that the query will include everything in that criteria. The plan is to query based on the Job number so that the expenses for each job can show up, but I want an All option so that the total expense can show up. I'm not really sure how to go about doing that. I tried using a listbox with multiselect, but that didn't work at all. Even when I had only selected one individual item, nothing returned in the query.

[pbaldy]

You could use one or both of these:

http://access.mvps.org/access/queries/qry0001.htm

http://access.mvps.org/access/forms/frm0043.htm

[beanhead0321]

Thank you very much

[pbaldy]

Happy to help.