creating a total

[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.

 

[John Spencer]

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

 

[Rick Brandt]

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.

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.