# Thread: Calulating in a Report

1. Registered User
Join Date
May 2002
Location
wakefield, ri
Posts
35

## Unanswered: Calulating in a Report

I have created three text fields that add totals in a report group footer i.e. =Sum([VerifyTime]), =Sum([LibEffort]), =Sum([CatalogTime]). Now I would like to add these fields in the same footer.

=Sum([VerifyTime]+[LibEffort]+[CatalogTime]) doesn't work.

Any suggestions out there. Thanks

2. Grand Poobah
Join Date
Sep 2003
Location
MI
Posts
3,713

3. Registered User
Join Date
Dec 2004
Posts
15
Originally Posted by M Owen

That is correct
Add a new text box looking on the 3 record for get the correct result.

4. Registered User
Join Date
Sep 2004
Location
Raleigh, NC
Posts
146
Originally Posted by gatewoodps
I have created three text fields that add totals in a report group footer i.e. =Sum([VerifyTime]), =Sum([LibEffort]), =Sum([CatalogTime]). Now I would like to add these fields in the same footer.

=Sum([VerifyTime]+[LibEffort]+[CatalogTime]) doesn't work.

Any suggestions out there. Thanks
Assuming the following:

[txtA]=Sum([VerifyTime])
[txtB]=Sum([LibEffort])
[txtC]=Sum([CatalogTime])

Create another text box and include the following in the Control Source:

=NZ([txtA])+NZ([txtB])+NZ([txtC])

5. Registered User
Join Date
May 2002
Location
wakefield, ri
Posts
35

## Calculating in a Report Footer

Putting =NZ([VerifyTime]+NZ[CMEffort]+NZ[CatalogTime]) as the Control Source gives me an inaccurate result.

I am adding numbers with decimals.

Is that the problem???

6. Registered User
Join Date
Sep 2004
Location
Raleigh, NC
Posts
146
Originally Posted by gatewoodps
Putting =NZ([VerifyTime]+NZ[CMEffort]+NZ[CatalogTime]) as the Control Source gives me an inaccurate result.

I am adding numbers with decimals.

Is that the problem???
Try the following and see if the results are correct:

=NZ([VerifyTime])+NZ([CMEffort])+NZ([CatalogTime])

Additionally, make sure that you are using the text box names and not the field names in your calculation. [VerifyTime],[CMEffort], and [CatalogTime] should be the names of the three text boxes involved. In terms of the decimals, I don't think they should be causing you a problem.
Last edited by smacdonaldnc; 12-23-04 at 19:50.

7. Registered User
Join Date
Dec 2004
Posts
15
Originally Posted by smacdonaldnc
Assuming the following:

[txtA]=Sum([VerifyTime])
[txtB]=Sum([LibEffort])
[txtC]=Sum([CatalogTime])

Create another text box and include the following in the Control Source:

=NZ([txtA])+NZ([txtB])+NZ([txtC])

This is easy. Create a new text box on the desing view for the report. On control put =+[txtA] + [txtB] + [txtC]
In datatype Put Currency and u have the calculator

8. Registered User
Join Date
Dec 2003
Location
Dallas, TX
Posts
1,004
Originally Posted by heman85
This is easy. Create a new text box on the desing view for the report. On control put =+[txtA] + [txtB] + [txtC]
In datatype Put Currency and u have the calculator
heman85, the user shows two fields as being TIME, so Currency won't work there.

BUD

9. Registered User
Join Date
Dec 2003
Location
Dallas, TX
Posts
1,004
Hi gatewoodps,

To better help things, just exactly are the FieldTypes for these three fields?? Seems that maybe we might be trying to add Apples to Tires which don't compute. Just by looking it seems that VerifyTime and CatalogTime are Date/Time fields? What about the LibEffort??? What is that??

have a wonderful Holiday
BUD

10. Registered User
Join Date
May 2002
Location
wakefield, ri
Posts
35

## Calculating in a report

Problem solved using the text box names for calculating.
Thanks to all

11. Registered User
Join Date
May 2002
Location
wakefield, ri
Posts
35

## Calculating in a Report

In a report I have groups named "Project" which has multiple values and "Request" which has only two values. In the "Request" group footer I have done totals of numbers from three fields (=NZ([VerifyTime])+NZ([CMEffort])+NZ([CatalogTime]). The problem I have is getting a grand total for the two values.

Any suggestions will be well received. Thanks.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•