[AccessD] Calculating Date/Time

Doris Manning mikedorism at verizon.net
Wed Oct 25 13:53:59 CDT 2006


You would need to control that through the Form or Report you are using to
display the results.

Doris Manning

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Hollis, Virginia
Sent: Wednesday, October 25, 2006 2:16 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] Calculating Date/Time

Thanks! Last question...
 
The Average shows like: 0.0909090909090909 how can I get it to show
without all the numbers - like round it?
 
DaysClose: DateDiff("d",[opendate],[clsddate])
 
 
Click on the "Group By" button.  Set the person information to "Group
By"
and set the calculated column to "Average".
 
Doris Manning

 

-- 
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