Jump to content


Photo
- - - - -

Access Help! (Please?)


  • Please log in to reply
4 replies to this topic

#1 Jeff L

Jeff L

    Senior Member

  • HUDDLER
  • PipPipPipPip
  • 648 posts

Posted 09 November 2012 - 09:14 AM

The assignment says to "Create the Student Fundraising Query: Display all projects table records with a calculation field named student amount that sums the 4 project amounts and multiplies the sum by 25%."

I have created the calculated field name StudentAmount and have the following in the field:

StudentAmount: [Project1Amt]+[Project2Amt]+[Project3Amt]+[Project4Amt]

That adds the 4 project amounts like it is supposed to. When I try to multiply that total by .25 (* .25) it goes crazy and gives me something other than the total it is supposed to be. For example, the first student total is $170.91. If I add * .25 to the end of the above forumula I get 120.915 which I know is way wrong. $170.91 divided by four is $42.72 which is the answer I should be getting.

Any ideas why it is not working?

#2 mr beauxjangles

mr beauxjangles

    Large Member

  • HUDDLER
  • PipPipPipPipPipPipPipPipPip
  • 3,397 posts

Posted 09 November 2012 - 09:19 AM

Is it possible that your order of operations is messed up and your equation is only multiplying Project4Amt by 0.25, then adding that result to the other 3 Project Amounts? In other words, is it calculating: Project1Amt+Project2Amt+Project3Amt+(Project4Amt*0.25) instead of (Project1Amt+Project2Amt+Project3Amt+Project4Amt)*0.25?

#3 Inimicus

Inimicus

    Life is better in a kayak

  • ALL-PRO
  • 6,101 posts

Posted 09 November 2012 - 09:21 AM

^^Beat me to it^^

order of operations.

You want ([Project1Amt]+[Project2Amt]+[Project3Amt]+[Project4Amt])*.25
you have [Project1Amt]+[Project2Amt]+[Project3Amt]+[Project4Amt]*.25

#4 Jeff L

Jeff L

    Senior Member

  • HUDDLER
  • PipPipPipPip
  • 648 posts

Posted 09 November 2012 - 09:37 AM

Thanks fellas! I came back to let everyone know I figured it out and you guys had already answered it! I was up until 12:30 this morning trying to figure it out!

Thanks again!

#5 Jackofalltrades

Jackofalltrades

    OWN the Line of Scrimmage

  • HUDDLER
  • PipPipPipPipPipPipPipPipPip
  • 17,625 posts
  • LocationNC

Posted 10 November 2012 - 08:55 PM

Wtf is all this nonsense?

I see numbers and plus signs, what up with all the letters?


0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

Shop at Amazon Contact Us: info@carolinahuddle.com