Creating a report by day in a month

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a dataset that contains verbal orders. It is required that verbal
orders are reviewed. The dataset have the order date/time and the review
date/time.

I need to create a report via a query that counts the number of orders that
are either not reviewed or were reviewed lonnger than 72 hours after order
for each day of the month.

Ex:order placed on 12/01/2004 it was reviewed on 12/05/2004 therefore it
would count as one order not reviewed on 12/04/2004 and 12/05/2004.

Can anyone help me set up this type of query for my report?
 
I would add the date and time stamp fields to each record there-by creating a
time stamp for every order......you can then build your report and insert an
expression in the source control to filter the report contents based upon the
date stamp for the order....I have done this to create daily logs for patient
seen every day etc and it works fine..the priinciple seems the same to me.
 
Back
Top