There is no way to do this without a holiday table. Sorry.
Calendar tables are extremely useful things. You can find some useful
information he
http://www.mvps.org/access/datetime/index.html

Michelle wrote:
Sorry if this is a duplicate, but I tried lots of searches here. I
can't seem to find my answer anywhere.

I have 2 tables that I need to join by date and ID. The problem is
that there is a day lag in one of the tables, i.e. date = 5/12/10 in
T1 is equivalent to date = 5/11/10 in T2. I cannot change the
structure of either of these tables, so please do not suggest that.
I need to be sure I'm comparing the proper dates between tables. I
can't simply do a dateadd -1 since there are holidays and weekends to
consider. I also don't want to have to create a holiday table since
it is one more thing that would have to be maintained. (Meaning it
would get forgotten.)

--
Microsoft MVP - ASP/ASP.NET - 2004-2007
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"