[AccessD] Two Stupid Access Questions.

Andy Lacey andy at minstersystems.co.uk
Fri Feb 28 11:42:00 CST 2003


Q1. Top of my head 

- create a Group Footer
- in there put a field with calculation =Count(YourField)
- set RunningSum property to something like Over Group or In group or
something like that

Andy Lacey
http://www.minstersystems.co.uk



> -----Original Message-----
> From: accessd-admin at databaseadvisors.com 
> [mailto:accessd-admin at databaseadvisors.com] On Behalf Of 
> Frank Tanner III
> Sent: 28 February 2003 16:28
> To: Database Advisors
> Subject: [AccessD] Two Stupid Access Questions.
> 
> 
> Question 1.  How do I do a running count of the number
> of records per group in a report.
> 
> Question 2.  I have a field called duration.  The
> field is a time field in the format hh:nn:ss.  I would
> like to sum this field, again based upon group.
> 
> Any information you can give me would be greatly appreciated. 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/a> ccessd
> Website: 
> http://www.databaseadvisors.com
> 
> 




More information about the AccessD mailing list