Setting up a query to run business day

W

WMorsberger

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.
 
P

pietlinden

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;
 
Top