Selasa, 29 Maret 2016

Re: [MS_AccessPros] limiting data from table

 

actually I had no idea what to us so I will try distinct thank you



---In MS_Access_Professionals@yahoogroups.com, <JohnV@...> wrote :

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 
(Paris, France)



On Mar 29, 2016, at 2:43 PM, pattykf@... [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: pattykf@cox.net
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (3)

.

__,_._,___

Tidak ada komentar:

Poskan Komentar