[AccessD] Every other Friday

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


More information about the AccessD mailing list