[AccessD] A2K Increase Year by 1

Excellent
Thanks John


----- Original Message ----- 
From: "John W. Colby" <jwcolby at colbyconsulting.com>
To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com>
Sent: Monday, April 05, 2004 9:19 AM
Subject: RE: [AccessD] A2K Increase Year by 1


> DateAdd
> 
> JWC
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Darren DICK
> Sent: Sunday, April 04, 2004 7:08 PM
> To: AccessD List
> Subject: [AccessD] A2K Increase Year by 1
> 
> 
> Hello all
> Brain fade here
> It's Monday morning and everything is just as you would expect a Monday to
> be <sigh>
> I have a dB that holds dates of Occurrences
> I have a  need to increase the 'year' portion only of that date by 1
> eg 31/01/2001 now needs to become 31/01/2002
> There are hundreds of 'em though so doing it manually isn't an option.
> I just need a quick query to update 'em all. I actually have done this is
> the past
> (on the same dB actually) but can't recall how I did it <sigh>
> 
> Many thanks in advance
> 
> Darren
> 
> --
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> 
> 
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com