Hey,



I have a table which has a multivalue combo box where the user can select the people who attended a training evening (each row is a new training evening).

I am now wanting to produce a report showing which training evening each person has come too. Ideally this report should be created by the user from a form by selecting the user from a dropdown box.

I understand that i will need to create a query to do this but i can't seem to use the information in the multivalue field. The field is called 'Attendees' and i also have access to a value of the field in 'Attendees.Value' but i can't seem to search it.

Hope this makes sense, i would attach the database but it has personal details included in it and so i can't share this information. Is there a way of just sharing the layout?

Regards

Adam