Date Range In Report?

Losartan

Registered User.
Local time
Today, 14:23
Joined
Jul 21, 2005
Messages
39
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
 

Users who are viewing this thread

Back
Top Bottom