Unanswered: Eliminate duplicate unique items in count
I have a patient database where of course each patient has their own unique ID# [PatientID]
I need to create reports to show the total amount of patients receiving services. In a period of time, any one patient can receive a few to several hundred services. Between my query and report, how can I achieve the "actual" number of patients without duplicates of the [PatientID]?
The database I'm working in actually pulls info from another DB, which unfortunately doesn't have the ability to create the exact reports that we need. I'm forced to create my relationships by building various queries and creating the relationships there...
The table (TicketDetail) is where I'm pulling the true (PatientID) from.
The (PatientID) is linked from (TicketDetail) to a query (qryLevel 1 Patients) that pulls specific patient types from the (TicketDetail) table also. This is necessary due to the fact that when a patient switches levels, a "ticket" is created to reflect this.
I know my way around the db fairly well, I apologize however, I'm not very well versed in the "technical" terms but I'm learning.