[AccessD] RE: Using Dates

Ah, a convert! <VBG>

Charlottet Foust

-----Original Message-----
From: Colby, John [mailto:JColby at dispec.com] 
Sent: Friday, January 30, 2004 11:06 AM
To: 'Robert L. Stewart'; accessd at databaseadvisors.com
Cc: Colby, John
Subject: [AccessD] RE: Using Dates


I think I finally "got it".  This is joined to any date to pull out the
various pieces needed?  Then you build a function to populate this thing
for the dates that your app needs?  

I think I might just appreciate this one!  ;-)

John W. Colby
The database guy


-----Original Message-----
From: Robert L. Stewart [mailto:rl_stewart at highstream.net]
Sent: Friday, January 30, 2004 1:58 PM
To: accessd at databaseadvisors.com
Cc: JColby at dispec.com
Subject: Re: Using Dates


Actually, you have a "standard" date dimension table that everyone uses
and 
the overhead is minimal.

At 12:00 PM 1/30/2004 -0600, you wrote:
>Date: Fri, 30 Jan 2004 12:58:44 -0500
>From: "Colby, John" <JColby at dispec.com>
>Subject: RE: [AccessD] Using Dates
>To: "'Access Developers discussion and problem solving'"
>         <accessd at databaseadvisors.com>
>Message-ID: <05C61C52D7CAD211A7830008C7DF6F1079BD12 at DISABILITYINS01>
>Content-Type: text/plain;       charset="iso-8859-1"
>
>I have to assume though that you only create these as required for 
>reporting?  The overhead would be enormous otherwise.
>
>John W. Colby


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com