Creating a report by day in a month

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:blush:rder 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?
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top