I am trying to get a list of home addresses for key sales reps (to send Christmas presents). The reps I want are in a table called "tblOfficeContacts" which also contains a field I want called "ContactName". The reps are assigned to various offices so their EMSRepID is repeated in the tblOfficeContacts table.
The reps are also included in a table called "RepsActive". The EMSRepID is unique- the rep is only listed once in this table. The RepsActive table contains the home address that I wish to extract. This table also includes a bunch of other reps that I don't want to select.
In other words, I want to select all the reps in the OfficeContacts table only once and get their home address from the RepsActive table.
No matter what I've tried, I'm unable to pull a list of reps from the tblOfficeContacts with their home addres from the RepsActive table without duplicating the rep records. OfficeContactsAddress.accdb