Multiple Record Sets

  • Thread starter Thread starter Simplyanjel
  • Start date Start date
S

Simplyanjel

Please help...

I am using access to gather information. Such as.. I need patient's with a
zero balance on there account. I have a used a query to return this
information however I have duplciates for every entry where the patient has a
zero balance they are appearing more than once. I have changed it to show
only unique in the properties and it shortend the results from 317,984 to
95949. But there are still duplicates. What am I doing wrong???

TIA for all your help!!!
 
I have resolved this issue... Once I stepped back and looked at the actual
data that I was getting, I saw that it was a field that needed to be
removed... After doing that I have resolved this issue.

THANKS~~~~
 
Back
Top