If date is Holiday then go back to prior BD

  • Thread starter Thread starter The Joker via AccessMonster.com
  • Start date Start date
T

The Joker via AccessMonster.com

Hello all,

I have what I think would be pretty easy issue to fix but I'm just brain dead
today I guess. I have a function which produces a date. All I need is to
see if that day is a holday. I have a table that has Holidays.. tblHolidays
containing 2 columns HolidayName and HolidayDt. I think I need some form of
a DLookup to see if the day is in the table and if so go back to the previous
business day. Anyone have some quick code that can achieve this? Thanks!
 
If Not IsNull("[HolidayDt]", "tblHolidays", "[HolidayDt] = #" & SomeDate
& "#" Then
'Go Back a day"
End If
 
Perfect!! Thank you very much, I really appreciate it!
If Not IsNull("[HolidayDt]", "tblHolidays", "[HolidayDt] = #" & SomeDate
& "#" Then
'Go Back a day"
End If
Hello all,
Click to expand...
[quoted text clipped - 4 lines]
a DLookup to see if the day is in the table and if so go back to the previous
business day. Anyone have some quick code that can achieve this? Thanks!
Click to expand...
Click to expand...
 
Back
Top