Multiple Selection

[GCLIFTON]

Need help



What is the sql that will allow me to select multiple selection a single drop down box. For instante if i have Building 10520,10560,15070. in a combo box. How can i Select 2 out of the three. Normally in programs you use the shift+ Mouse to select more than one.

SELECT DISTINCT TBL_NSF_Data.[Building Number]
FROM TBL_NSF_Data
ORDER BY TBL_NSF_Data.[Building Number];

[pbaldy]

Normally I'd use a listbox with the multi-select property set appropriately. For a report, used like:

http://www.baldyweb.com/multiselect.htm