[AccessD] Should Business use Access?

Arthur Fuller fuller.artful at gmail.com
Wed May 7 11:19:48 CDT 2014


Darryl,

Nice example. Thanks for offering it.

Arthur


> There is no way in hell you are going to do something like "UPDATE
> GST_RATE to .15" globally and have it work.
>
> You need to have a table live (Using GST_RATE as the example here)
>
> StartDate       | EndDate               | Rate
> 1-Jan-2001         31-Dec-2001             0.05
> 1-Jan-2002         31-Jul-2004             0.07
> 1-Aug-2004         31-Dec-2006             0.85
> 1-Jan-2007         31-Jul-2007             0.67
> Etc...
>
> Cheers
> Darryl


More information about the AccessD mailing list