Access: Total of a single record

R

Robert Kemp

how do I add an ongoing record.
Example: Feet equal to one record/field, how would I add up the total of
that record to get the total of all entries for feet into a differant record.
Date Section Pounds Ran Feet
5/10/2007 13.0 504.00 12.65
5/10/2007 13.0 504.00 16.88
5/10/2007 13.0 604. 15.16
5/10/2007 13.0 604.00 20.23
5/11/2007 13.0 1,256.00 31.53
5/11/2007 13.0 1,256.00 42.08
5/11/2007 13.0 18.00 0.45
5/11/2007 13.0 18.00 0.60
 
W

Wayne-I-M

Hi Robert

I'm not sure I understand your question. "think" you want to total the
field feet.

If you are working on a form you could place an unbound text bo in the foot
of the form with the source of
=sum([feet])
Change the field name if it's not "feet".

In a query you could run a totals query and this would give you the total.

Hope this helps

Oh - don't store the result in any field as you will find this a problem if
you add another record - this would mean the result was not wrong as it
wouldn't include the new record. You can laways sum the field whenever you
need it so don't store it.
 
Y

yuhuadong

Wayne-I-M said:
Hi Robert

I'm not sure I understand your question. "think" you want to total the
field feet.

If you are working on a form you could place an unbound text bo in the
foot
of the form with the source of
=sum([feet])
Change the field name if it's not "feet".

In a query you could run a totals query and this would give you the total.

Hope this helps

Oh - don't store the result in any field as you will find this a problem
if
you add another record - this would mean the result was not wrong as it
wouldn't include the new record. You can laways sum the field whenever
you
need it so don't store it.




--
Wayne
Manchester, England.



Robert Kemp said:
how do I add an ongoing record.
Example: Feet equal to one record/field, how would I add up the total of
that record to get the total of all entries for feet into a differant
record.
Date Section Pounds Ran Feet
5/10/2007 13.0 504.00 12.65
5/10/2007 13.0 504.00 16.88
5/10/2007 13.0 604. 15.16
5/10/2007 13.0 604.00 20.23
5/11/2007 13.0 1,256.00 31.53
5/11/2007 13.0 1,256.00 42.08
5/11/2007 13.0 18.00 0.45
5/11/2007 13.0 18.00 0.60
Click to expand...
Click to expand...
 
Top