Re: [MS_AccessPros] Getting unique records in access 2013

 

Jorge-

If you want to include details about each unit, then it's not possible when you create a query on owners and units because the owners who own multiple units will show up once for each unit.

Please explain in more detail what you want the output to look like.  Try constructing a sentence that describes what you want.  Something like:

"Display all owners and their email address who own units in resort A."

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications 

SQL Queries for Mere Mortals 

http://www.viescas.com/ 

(Paris, France)

On Sep 8, 2015, at 5:40 AM, Duane Hookom duanehookom@hotmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

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

__._,_.___

---

Posted by: John Viescas <johnv@msn.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (3)

Visit Your Group

• New Members 1

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___