Delete duplication

  • Thread starter Thread starter Yolanda
  • Start date Start date
Y

Yolanda

I have a table which lists clients names and comments. I
have another table with clients names and various dates
of services. My dilema is when I create the query
duplicate information is given due to the different dates
of services. Example:

Client Name: Dates of Services Comments

Joe Smith 1/1/01 to 2/1/01 Examination
4/1/01 to 4/3/01

When I do the query (I am using parameters to select
dates of services in a particular range), since I have 2
different dates of service but 1 client and 1 comment,
the query returns both service dates and same comments.
I do not want this. What do I need to do to stop this
from occuring. I have gone into distinct values which
did not work, I changed the Unique Value/Record to
indicate yes and this still gives me duplicate
information. Is there some kind of formula that I must
use to make this stop or alternate method?
Thanks for any suggestions.
 
The results you describe are consistent with an inner join
on the two tables. If this is not what you want, could you
elaborate on what you do want to see.

Gerald Stanley MCSD
 
Thank you for your reply Gerald.

Basically what I want is: Even though our clients were
serviced at different times, I don't want the comments
showing up for every time they were serviced. I only
want their comment showing up once even though there were
serviced on several different dates. Does this make
sense to you?
 
Unfortunately for you, what you want to happen is not the
way SQL behaves. All columns will be populated in the
output of a query if there is data in the underlying
tables. Normally this is hidden from the end users by
designing forms and reports that show the 'duplicated' data
once only.

Hope This Helps
Gerald Stanley MCSD
 
Back
Top