Create a totals/group by query. Don't include any fields/columns that aren't necessary. If you have any questions, please provide your table and field names.
Duane Hookom, MVP
MS Access
To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Mon, 7 Sep 2015 15:48:50 -0700
Subject: [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
Duane Hookom, MVP
MS Access
To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Mon, 7 Sep 2015 15:48:50 -0700
Subject: [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: Duane Hookom <duanehookom@hotmail.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar