Calculate in Report Text Box

L

Lamar

I am trying add to fields from an underlying query in a report text box:

=[TotChkCal]+[SplitCal]

But it puts it together instead of adding it. ie if TotChkCal is 180 and
SplitCal is 20 - it gives me 18022 instead of 200.

I have to put the fields in text boxes on the report then add in another
text box:

=[txtTotChkCal]+[txtSplitCal] - it does the samething

I can not do it in the query because I have other calculations and when I
try to Sum the fields then I get the "Too complex" error. This is why I was
trying to sum the totals in the report.

Any help is appreciated.
 

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

Top