Calculation in text box not working

I am grouping cost by group - I want the report to look like this:

MAY COST FIGURES

GROUPHEADER=====================
Brachman Project
Total Spend: $150,000

DETAIL=============================
Engineering : $50,000 33% of total spent
Design: $100,000 67% of total

my control name in the detail section is DeptSum that shows the breakdown; I
also have a text box in the header section showing total spend by project -
it is an unbound text box with the following formula:

=SUM([Team Sum By Vendor]) - the name of that control is txtDeptSum

I want to have a text box that will show the pct breakdown in an unbound text
box - I try to put

=SUM([DeptSum]/[txtDeptSum])

in the detail section, but it doesn't work - I asked someone, and they said
don't use the control names, but I'm almost positive this should work

Any ideas ?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ports/200512/1

"but it doesn't work" isn't too descriptive. However, try:
=[DeptSum]/[txtDeptSum]


--
Duane Hookom
MS Access MVP


"Steven R via AccessMonster.com" u12024@uwe wrote in message
news:5870eb36fce3f@uwe...
I am grouping cost by group - I want the report to look like this:

MAY COST FIGURES

GROUPHEADER=====================
Brachman Project
Total Spend: $150,000

DETAIL=============================
Engineering : $50,000 33% of total spent
Design: $100,000 67% of total

my control name in the detail section is DeptSum that shows the breakdown;
I
also have a text box in the header section showing total spend by
project -
it is an unbound text box with the following formula:

=SUM([Team Sum By Vendor]) - the name of that control is txtDeptSum

I want to have a text box that will show the pct breakdown in an unbound
text
box - I try to put

=SUM([DeptSum]/[txtDeptSum])

in the detail section, but it doesn't work - I asked someone, and they
said
don't use the control names, but I'm almost positive this should work

Any ideas ?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ports/200512/1

Duane,
Thanks so much - that was the trick - just leaving out the SUM part of the
equation. Sorry for the vague-ness - when I said "It didn't work," I got
message prompts referencing the names in my formulas

Steve


Duane Hookom wrote:
"but it doesn't work" isn't too descriptive. However, try:
=[DeptSum]/[txtDeptSum]

I am grouping cost by group - I want the report to look like this:

[quoted text clipped - 27 lines]

Any ideas ?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ports/200512/1