February Presentation PDF Available: Microsoft Access Multi-valued fields
Attached is the PDF from the Feb meeting for your reference. Also note that the video from approximate 16:10 – 21:00 contains updated information about using multi-valued fields as SELECT Criteria that you may want to review even if you attended the meeting. Finally, a follow up on Deleting values.
DELETE MultiValueAccessList.MultiValuedColumn.Value
FROM MultiValueAccessList
WHERE MultiValueAccessList.MultiValuedColumn.Value=”Choice 2″ AND MultiValueAccessList.PersonName=”Person 1″;
Gives a Enter Parameter Value prompt for MultiValueAccessList.PersonName (this is likely a bug but still trying to verify). If you flip the order of the WHERE the below works and deletes the 1 choice.
DELETE MultiValueAccessList.MultiValuedColumn.Value
FROM MultiValueAccessList
WHERE MultiValueAccessList.PersonName=”Person 1″ AND MultiValueAccessList.MultiValuedColumn.Value=”Choice 2″ ;