A
Access101
I have a ONE to MANY relationship with Contacts and their multiple Addresses.
I know how to make it so that the ONE record shows up only once when I use a
Report/Form (and then of course multiple MANY records show up in the
SubReport/SubForm)
However, in a query, I would like a Contact to show only once--even if it
has many addresses.
The problem comes in when I need the Addresses Table as part of the query in
order to pick only certain address types. (I don't want to display the
address types, I just want to display any Contact with those types, but only
display the Contact once)
I've struggled with "Totals" queries (Group By), but am still not making
progress.
Any help is appreciated.
Is there a way to do this in a query?
I know how to make it so that the ONE record shows up only once when I use a
Report/Form (and then of course multiple MANY records show up in the
SubReport/SubForm)
However, in a query, I would like a Contact to show only once--even if it
has many addresses.
The problem comes in when I need the Addresses Table as part of the query in
order to pick only certain address types. (I don't want to display the
address types, I just want to display any Contact with those types, but only
display the Contact once)
I've struggled with "Totals" queries (Group By), but am still not making
progress.
Any help is appreciated.
Is there a way to do this in a query?