Date Ranges Between

[mous]

Hello

I'm using Access 2000.

I have a form containing two dates : a start date and an end date. After the user has entered these dates a no of weeks field calculates the weeks between the two.

I have a fixed number of dates : i.e. bank holiday dates that I know

My question is how can I get access to check whether these holiday dates fall inside those entered by the user without using a query?

Thanks for any help.

 

[alcifer_c]

Are the holiday dates stored in a table?

 

[Mile-O]

If you'd searched you have found quite a bit on UK Bank Holidays

 

[mous]

This has not really answered my question. Yes the Start and End Date are stored in tables. I don't know how to reference tables from a Module.

Thanks


Dawn

 

[Mile-O]

Dim intHolidays As Integer
intHolidays = DCount("HolidayField", "HolidayTable", "[HolidayField] Between #" & Me.txtStartDate & "# And #" & Me.txtEndDate & "#")

THen with intHolidays, you can subtract it from your working days and then calculate the weeks.