[AccessD] Two Stupid Access Questions.

Ok...I figured them out..  Here's how I did it.  BTW:
A similarthing worked for both the duration time and
the quantity of records.

I created a text box within the group that equalled 1.
 I then summed over the group.  I set the text box to
invisible, and put a text box in the group footer that
equalled the summed count text box.  This gave me my
record count.

To create the duration sum, I made the invisible
textbox equal the duration field and summed across the
group.  Then U put a text box in the group footer
equal to this invisible text box.

If anyone else has any issues similar to this, you now
have the info on how the simplest way to do it is.

--- Andy Lacey <andy at minstersystems.co.uk> wrote:
> 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
> > 
> > 
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com