Hey Guys,
I have a DB with a 4 tbls:
MedRecAudit; Physicians; Unit; PracticeName
I have a query that finds only physicians from a particular practice and whether they filled out a particular order.
One portion of the query is AuditDate. I use a between statement to limit the dates.
I then have another query based on the first query that sums the yes/no statements and calculates the % of times the form is completed.
I have a report the runs from query 2 and works perfectly. Is there a way to have the date range automatically populate based on what I put in as the range?
Thanks,
Jason
I have a DB with a 4 tbls:
MedRecAudit; Physicians; Unit; PracticeName
I have a query that finds only physicians from a particular practice and whether they filled out a particular order.
One portion of the query is AuditDate. I use a between statement to limit the dates.
I then have another query based on the first query that sums the yes/no statements and calculates the % of times the form is completed.
I have a report the runs from query 2 and works perfectly. Is there a way to have the date range automatically populate based on what I put in as the range?
Thanks,
Jason