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