A delete query can be used in two ways on multi valued fields. You can delete records that contain a particular value in a multi valued field or delete a value from a multi valued field in all the records in the table. How to delete the values depends on the source of the values in a multi valued field. If the source is from a different table then you need to use bound value to delete the values.
To download the example Access file please click on the link below
https://www.findeasysolution.com/Down...
To learn more about multi valued fields please click on the link below
• MS Access Multi valued fields