Calculation between start date & end date

[Hazel]

I have a form which has a start date field & end date field
i have a query that works out how many days from start date to end date that excludes weekends now my boss wants it to exclude any holidays we may have such as bank holidays etc
can any help me with this
i think i need a module and a new table with all the holidays in it
i am right or iam i going crazy?

 

[RV]

Indeed you could create a hoilday table.
Include this table in your query to exclude any holiday days.
No module required.

RV

 

[modest]

Agreed. Set up an "Exclusion Table" ---> You may need a module to calculate the holidays this is because some holidays dont fall on the same day every year: they have silly rules like "The first Tuesday after the Second Monday in December"

Window's calendar may also have a default set of holidays, but the easiest way to manage is to set your own table up.

 

[ejstefl]

Check this out for a detailed description on how to do it. It does require a holiday table, though.

http://www.mvps.org/access/datetime/date0006.htm