Access

[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.

 

[Dave R.]

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.

 

[Frank Kabel]

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

 

[onedaywhen]

Are you querying Excel data within the MS Access GUI, a linked table
perhaps? Take a look at the SQL keyword 'DISTINCT'.

--