Thread: Anyone can help me with calculating total in Acess?

1. Registered User
Join Date
Mar 2004
Posts
10

Unanswered: Anyone can help me with calculating total in Acess?

2. Registered User
Join Date
Nov 2003
Posts
267
How big is it?

S-

3. Registered User
Join Date
Mar 2004
Posts
10
Originally posted by sbaxter
How big is it?

S-
500K

4. Registered User
Join Date
Mar 2004
Posts
10

Here is the database

Go to report, summary, if you take look at the yellow line and gray line. some of the calculation is not right, example: go to 22-329, the total should be 49,267+100,000 =149,267, but now it's 49,267+49,267+100,000. Is it possible to write some code behind it??

5. Registered User
Join Date
Mar 2004
Posts
10

Re: Here is the database

Originally posted by luckyrl
Go to report, summary, if you take look at the yellow line and gray line. some of the calculation is not right, example: go to 22-329, the total should be 49,267+100,000 =149,267, but now it's 49,267+49,267+100,000. Is it possible to write some code behind it??
ANYONE??

6. Registered User
Join Date
Jan 2004
Location
Kennesaw, Ga
Posts
20

Re: Here is the database

Originally posted by luckyrl
ANYONE??
The formula for the total in the grey section is as follows:

=Sum([rptComm])-Max([SumComm])

You can look at the report in design and then get the properties on that individual field.

The report is based off of qryCostTotal
Looking at the qryCostTotal for Funds Center 22-329, it appears to be taking the total from the rptComm column which is \$298,534.54 and subtracting the max value from the SumComm which is \$100,000.00.
To get the correct value that you may be looking for you would change the formula so that it is as follows:

=Sum([rptComm])-Sum([SumComm])

HTH

7. Registered User
Join Date
Mar 2004
Posts
10

Re: Here is the database

Originally posted by agduga
The formula for the total in the grey section is as follows:

=Sum([rptComm])-Max([SumComm])

You can look at the report in design and then get the properties on that individual field.

The report is based off of qryCostTotal
Looking at the qryCostTotal for Funds Center 22-329, it appears to be taking the total from the rptComm column which is \$298,534.54 and subtracting the max value from the SumComm which is \$100,000.00.
To get the correct value that you may be looking for you would change the formula so that it is as follows:

=Sum([rptComm])-Sum([SumComm])

HTH