Sample Header Ad - 728x90

Query of multi-valued field

1 vote
2 answers
1896 views
I have 2 tables: - Contacts - Helpers The Helper field (which is linked to the Helper table) in Contacts is a multi-valued field so more than one helper can be selected and displayed in a report. Each Helper is linked to more than 1 Contact. I'm trying to create a query selecting all contacts for one helper, and display all helpers for the resulting contacts. I think I am off-base with multi-valued fields, but cannot find another solution. It is in Access 2010. Tables do not have multi-value fields. They are: ### Contacts ContactID Surname Email ### Helper HelperID Name
Asked by Sue Snyder (11 rep)
Jun 27, 2015, 01:17 AM
Last activity: Oct 31, 2018, 12:02 PM