report to limit to a number of companies

[tizwaz]

I need to do a report which the user can select whether to include all companies, one company or a variable number of companies (anything up to 24)
I can do all or one using a combo box but how would I achieve the option to select several companies without having up to 24 different combo boxes and a complicated If statement?

 

[EliseFreedman]

Try using a list box instead of a combo box which will allow you to select more than one option at a time

 

[tizwaz]

If I used a list box how would I word my query or code so that the report would include all the selected entries in the list box?

 

[EliseFreedman]

For lots of help on using list boxes, take a look at the developer solutions database which ships with Microsoft Office. You may have to re-install office and select sample databases to install it

 

[EliseFreedman]

Also take a look at this link

http://www.mvps.org/access/forms/frm0007.htm

If you still need help, try searching in google newsgroups for "Using Multi-select list boxes as query criteria ". I found lots of useful posts