S
Slez via AccessMonster.com
OOPS!...Hit something as I was typing that made it post...Here is the
"complete" post!
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'd like the sum of what shows up in the BidTotal control per ProjectName, so
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]
=Sum([LineTotalSellPrice])+Sum([SalesTaxAmount])+Sum([UseTaxAmount])
All of these have failed to work. In the first 2 cases, it prompts me for
BidTotal when I run the report.
What am I doing wrong?
Any help is appreciated!
Slez
"complete" post!
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'd like the sum of what shows up in the BidTotal control per ProjectName, so
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]
=Sum([LineTotalSellPrice])+Sum([SalesTaxAmount])+Sum([UseTaxAmount])
All of these have failed to work. In the first 2 cases, it prompts me for
BidTotal when I run the report.
What am I doing wrong?
Any help is appreciated!
Slez