Performing calculations in text field from text field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form where I used a text field to calculate "totalhrs". Now I am
creating a report where i want a total of all the the hours scheduled per
machine. I have set up a footer in my report. I have tried different
formulas, and it is not working: i.e. =sum([totalhrs]) and =sum([text3]). It
does not recognize the text field.
What can I do to get a text box calculation to perform another function. Am
I looking at this the wrong way?
Thanks,
 
Hi.

Add a control to the Report Footer that sums the calculation. In other
words, if your "totalhrs" control in the Detail section has a Control Source
of:
=[Field1]*[Field2]
then place a control in the Report Footer with a Control Source of:
=Sum([Field1]*[Field2])

-Michael
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Assigning values to text for calculation 0
Sum time calculation in section footer of report 1
Sum Record per Record 6
Access MSACCESS - Sorting report based on field calculated in the report 0
Can't refer to Detail Report control on Page Footer? 3
calculating column totals in a report 4
sum of calculated fields in header of report 1
Calculated Field Issue 9

Back
Top