capturing records when criteria falls on weekend or holiday

[Guest]

I have a query which displays customer accounts overdue by 15 days. Each
day, the user generates a letter to all 15 day accounts. When day 15 falls
on a weekend or holiday, these accounts are being excluded since the days
overdue is greater than 15 when the user attempts to run the query the next
time. Is there a way to capture these records and include them in the 15 day
overdue accounts. I am using the same critieria for 30 and 60 day accounts
as well.

 

[Guest]

As far as I know there is no simple query done with query builder that will
fit your needs. The simplest solution is have a form with a report date
defaulted to today on it and allow them to change the report date so every
monday they would run the report 3 times for 3 days(sat,sun and mon). In
order to do what you want in a query you would need to build it in vba. for
further reference on how to build sql's in vba use this site.

http://www.fontstuff.com/access/acctut17.htm

HTH
Martin J