Setting up a query to run business day

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

Guest

I have pulled modules for setting up business days in my queries - I'm stuck
on where exactly the modules go and what I need to do to run the module for
my report to start a count of days after something is older then 3 days.
Again being new at this I'm not quite sure about code and modules.
 
WMorsberger said:
I have pulled modules for setting up business days in my queries - I'm stuck
on where exactly the modules go and what I need to do to run the module for
my report to start a count of days after something is older then 3 days.
Again being new at this I'm not quite sure about code and modules.
Click to expand...

you could filter your report for the data more than three days old.
SELECT tblTimeCard.DateTimeIn, tblTimeCard.DateTimeOut,
tblTimeCard.ClockID, DateDiff("d",[DateTimeIn],Now()) AS DaysOld
FROM tblTimeCard;
 
Back
Top