Tags: access, box, calculation, cost, database, figuresgroupheaderbrachman, group, grouping, microsoft, mysql, oracle, projecttotal, report, sql, text, thismay, working

Calculation in text box not working

On Database » Microsoft Access

3,210 words with 2 Comments; publish: Fri, 06 Jun 2008 12:57:00 GMT; (25093.75, « »)

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 droptable.com

http://www.droptable.com/Uwe/Forums...ports/200512/1

All Comments

Leave a comment...

  • 2 Comments
    • "but it doesn't work" isn't too descriptive. However, try:

      =[DeptSum]/[txtDeptSum]

      Duane Hookom

      MS Access MVP

      "Steven R via droptable.com" <u12024.ms-access.itags.org.uwe> wrote in message

      news:5870eb36fce3f.ms-access.itags.org.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 droptable.com

      > http://www.droptable.com/Uwe/Forums...ports/200512/1

      #1; Fri, 06 Jun 2008 12:59:00 GMT
    • 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:[vbcol=seagreen]

      >"but it doesn't work" isn't too descriptive. However, try:

      > =[DeptSum]/[txtDeptSum]

      >[quoted text clipped - 27 lines]

      Message posted via droptable.com

      http://www.droptable.com/Uwe/Forums...ports/200512/1

      #2; Fri, 06 Jun 2008 13:00:00 GMT