Archived

This topic is now archived and is closed to further replies.

Access Help! (Please?)

5 posts in this topic

Posted · Report post

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?

Share this post


Link to post
Share on other sites

Posted · Report post

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: [color=#282828][font=helvetica, arial, sans-serif][background=rgb(242, 242, 242)]Project1Amt+Project2Amt+Project3Amt+(Project4Amt*0.25) instead of ([/background][/font][/color][color=#282828][font=helvetica, arial, sans-serif][background=rgb(242, 242, 242)]Project1Amt+Project2Amt+Project3Amt+Project4Amt)*0.25?[/background][/font][/color]

Share this post


Link to post
Share on other sites

Posted · Report post

^^Beat me to it^^

order of operations.

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

Share this post


Link to post
Share on other sites

Posted · Report post

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!

Share this post


Link to post
Share on other sites

Posted · Report post

Wtf is all this nonsense?

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

Share this post


Link to post
Share on other sites