[AccessD] Date Diff Help It cant be this hard

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





More information about the AccessD mailing list