Distinct Query

[mary10k]

Hello,
I have a table called providers with the following 3 fields:

Provider ID
Cancellation Reason
Visit ID
Date

It is possible to have multiple instances of the same provider ID, cancellation reason and visit ID on the same date. I'm trying to count just 1 instance based on visit ID if there are multiple instances of the visit ID and reason on the same date. Select distinct doesn't seem to do the trick.

Could you please provide some direction?
Thank you.

 

[jdraw]

From your brief post, I see

Providers
Visits
as separate Entities.

Cancellation would seem to be an attribute of Visit.

Date is a reserved word in Access and should NEVER be used as a field name.

It is easier for readers (and you) to understand WHAT you are trying to do by writing a clear , concise description of WHAT your proposed database is about in simple, plaiin English.
You really should work through a tutorial such as this one from RogersAccessLibrary. You will learn some basic database design concepts that will help you significantly.

Good luck with your project.