creating a total

  • Thread starter Thread starter freelancer
  • Start date Start date
F

freelancer

Afternoon all,
In my dbase I have a field which records amount of time spent on particular
jobs i.e. 1.5 (hours) 2 (hours). The field is currently a text field. I
would like to be able to total this up and place the total in the footer of a
report. Can this be done?

Any responses will be gratefully appreciated.
 
Add a control to the report's footer

Set its source to
=Sum(Val([YourTimeFieldName]))



John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
 
freelancer said:
Afternoon all,
In my dbase I have a field which records amount of time spent on
particular jobs i.e. 1.5 (hours) 2 (hours). The field is currently a
text field. I would like to be able to total this up and place the
total in the footer of a report. Can this be done?

Any responses will be gratefully appreciated.
Click to expand...

First a question...

WHY are you using a text field to store numerical values particularly since
you also want to perform arithmetic operations on the value?

You can use =Sum(Val(YourFieldName))

Val() will convert the text to a numerical value upon which the Sun() can
then operate.
 
Back
Top