February Presentation PDF Available: Microsoft Access Multi-valued fields

By | March 5, 2019

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″ ;

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.