Bob Gajewski
rbgajewski at adelphia.net
Sun Jan 8 23:19:49 CST 2006
Check out http://www.mvps.org/access/datetime/date0001.htm -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Joe Hecht Sent: Monday, January 09, 2006 00:05 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Date Diff Help It cant be this hard They say if it works ugly can be pretty. My age solution for unbound text box =Left (((Now ()-[DOB])/365),2) Anyone have a better or more accurate way to do this? Joe Hecht jmhecht at earthlink.net -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Joe Hecht Sent: Sunday, January 08, 2006 8:56 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Date Diff Help It cant be this hard Tried a different route. txtAge is unbound control Data source txtAge=((Now()-[DOB])/365) Set decimals to 0 in format Getting 65.70923 etc Tied various number formats. The 65 is right in test form. Can not kill the decimal What dumb thing did I forget now? Joe Hecht jmhecht at earthlink.net -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan Sent: Sunday, January 08, 2006 8:44 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Date Diff Help It cant be this hard On 8 Jan 2006 at 20:39, Joe Hecht wrote: > Why cant I get the proper age to return. ... > Private Sub Report_Open(Cancel As Integer) Try doing it in the "on_format" for a header or detail. -- Stuart -- 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com