Senin, 07 September 2015

[MS_AccessPros] Getting unique records in access 2013

 

Hi Folks, I hope you are all having a fantastic Labor Day!!!

I need some help.

I have query that returns multiple records.

It is a list of owners at a resort.

The owners can have many units at the resort so an owner will be shown multiple times.

Every owner has just one email.

I would like to see only one record per owner.

How do I get my query to return only the one record for owner base on the email field.

Thanks.

Jorge Muralles


__._,_.___

Posted by: muralles_r12@yahoo.com
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)

.

__,_._,___

Tidak ada komentar:

Posting Komentar