[AccessD] Calculating Date/Time

Hollis, Virginia hollisvj at pgdp.usec.com
Wed Oct 25 13:15:54 CDT 2006


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

 




More information about the AccessD mailing list