Re: [MS_AccessPros] limiting data from table

 

Patty-

What's the SQL you're trying to use?  Consider using DISTINCT.

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 Mar 29, 2016, at 2:43 PM, pattykf@cox.net [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

I have  a table (I did not design it) that has a field called claim_id, charge_id, enc_id plus others

the claim_id and enc_id become duplicate rows due to charge_id having multiple charges on the same claim/encounter. How can I pull the data from this table where I would only get the claim_id/enc_id to show up unduplicated?

thank you 

Patty

__._,_.___

---

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 (2)

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___