Gary Kjos
garykjos at gmail.com
Thu Feb 21 13:31:33 CST 2013
In the data warehousing world we use a DATE TABLE for that kind of stuff. I fought the concept at first but have since drank the Kool Aid and seen the light. GK On Thu, Feb 21, 2013 at 1:23 PM, David McAfee <davidmcafee at gmail.com> wrote: > Okay, I have a question for the Access community :) > > > If every other Friday (starting Feb 22nd 2013) is a Furlough Friday (office > is closed), is there a way to determine if a given date such as August 16th > 2013 is available for a meeting? > > I'm thinking something to do with Mod 14 maybe? > > SQL or VBA answers are fine. > > Thanks in advance. > > David McAfee > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com -- Gary Kjos garykjos at gmail.com