trouble with SUM function

  • Thread starter Slez via AccessMonster.com
  • Start date
S

Slez via AccessMonster.com

I am not getting a control on a report to sum properly.
Groups are as follows:
ProjectName
BidNumber
Detail Section

The BidNumber footer has a control named "BidTotal" in which the Control
Source is:
=Sum([LineTotalSellPrice])+[SalesTaxAmount]+[UseTaxAmount]
This works perfectly!
LineTotalSellPrice exists in the detail section and the other 2 exist in the
BidNumber header.

I added a control in the ProjectName footer and tried the following 4
expresiions in the Control Source:
=Sum(BidTotal)
=Sum([BidTotal])
=Sum([LineTotalSellPrice])+[SalesTaxAmount]+[UseTaxAmount]
 

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

Similar Threads

trouble with SUM function - Repost 3
Trouble with Sum on Report 3
Need help with sum on a report 4
Total not correct in Footer 2
add bound fields for sum in unbound field 7
Another Running Sum 3
Running Sum 13
Count function trouble 0

Top