Dates in reports

[jay-em]

How do I display business days only in my Access queries vs. calendar days?

Thx
J--:hr:

[Digitalosophy]

I really don't know what you mean jay. I've seen this thread here for a while, maybe try expanding on what you'd like to do.

[jay-em]

Well, I am helping someone with a fairly simple database.
There have been several query reports built.
These "reports" are executed by entering a date range.
We need to know how to EXCLUDE weekends and holidays from displaying in our reports.
Basically, we have a deadline date and a complete date. We use these queries to find what has exceeded the deadline date. If weekends and holidays are included then it throws off the no. of "days open" in our reporting.