Adding two calculated fields into a third

[bobbynogs]

I am having difficulty in getting a total to be calculated in a text box in my report footer.

I have two calculated fields that are located in the report footer and work they are:

txtRITotal =Sum([Hours Worked]*6.31*24)

txtNXTotal =Sum([Fee])

They are both formatted to display as currency and they work perfectly as far as I can tell,
now the problem that I have is that I want to be able to take the results of those two fields
and add them together to make a Total field but,



=[txtRITotal]+[txtNXTotal]

only displays #Name?

I have tried numerous other different formulas and I always get #Name? as a result.

Can anyone assist please?

[ranman256]

try:
txtbox = (Sum([Hours Worked]*6.31*24)) + (Sum([Fee]))

[bobbynogs]

Thanks you very much, was sure I tried that one, must have managed to mess it up.
Feel so stupid :3.

[bobbynogs]

I wonder if you could help me once more.

I have a query that contains a calculated value, Hours Worked: [Time Out]-[Time In]-[Break Length]
which works as it's supposed to but as in my OP this then gets used for the following;
=Sum([Hours Worked]*6.31*24)
which also works but I have just realised if the break length contains half an hour as it quite possibly do then wouldn't the currency field round up instead of down?