How do i compute totals on a form, subform or a report.

My form and report are based on a query, i tried to the sum symbol in query design but its giving me something that i dont understand.

Please Help

=[Field1] + [Field2]

for strings....

=[Field1] & " " & [Field2]


What is the something strange it is giving you?

I think I might be able to help you out on this one, at least in the "report" area.

In the footer of your report, use the following formula and reference the field that has the figures you want to total:

=SUM([FIELDNAME])

Hope that helps.