Archived

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

Access Help! (Please?)

5 posts in this topic

Posted

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

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?

Share this post


Link to post
Share on other sites

Posted

^^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

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

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