Multiselect Listbox passing to a field

[PolarBear]

OK - I have seen the other posts where individuals are trying to select multiple items from a list box and have a field populate with the selections. I have not seen a clear explanation defining if this is possible.

Essentially, I want to be able to query on the field and search for multiple selections within that field. Any recommendations as to how this can be achieved?

My next question, is if the selections in a multiple instance field are separated by a comma or some other character what is the best method to query for multile responses. For example, if the following data is in the field 1,2,3 and I want to query on 1 or 2?

Regards,
PolarBear

 

[PolarBear]

Thanks for the reply. I have an appreciation for normalization. I guess I was searching for a solid answer which you provided. I also make use of SQL server and we have a front end progam that allows us to create multiselect fields. This is very useful when we run queries and search for multiple responses within a field. For example, an individual responds to a survery asking what summer activities do you like? The individual can respond and indicate activities A,B,D,F. This data is then stored in a field called Activities.
Then when we run queries, even using Access against the SQL database we can search for multiple responses in Activites field. For example, I may query on everyone that is interested Activity A AND D adn set the criteria accordingly.

Any additional comments would be appreciated.

Regards

Polar Bear