Access

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

Yolanda Schultheiss

I'm trying to run a report and query in Access. I am
utilizing several different dates of admissions for the
same client. What do I need to do to stop the
duplication of information when there are different
admissions for the same client?

Any suggestions? Thanks.
 
You might try asking this (but only ask it once, not twice) in an Access
newsgroup rather than an Excel newsgroup, though perhaps a
jack-of-all-office-applications will see it here and help.
 
Hi
I would create a query in MS Access to filter out the duplicates (you
may use the duplicate wizard in Access for this). In Excel use this
query as datasource
 
Are you querying Excel data within the MS Access GUI, a linked table
perhaps? Take a look at the SQL keyword 'DISTINCT'.

--
 
Back
Top