Access - Queries Question

Question

Hi.

I am trying to do some homework and can not seem to figure out how to do this.  I am trying to add a 4th column to the design grid, create a new field named Sponsor Donation that will calculate and display the donation amount when the sponsor donates an amount equal to 50% of each box office receipts amount to the music department.  

So I went to zoom in the 4th column and brought up the display box and entered

Sponsor Donation:[Amount]*0.5 

I also tried different combinations of music following.  It keeps either giving me an error message or a pop up telling me to enter an amount.  

Help I'm stuck.

Thanks

J

Answer 1

Sponsor Donations: [Box Office Receipts]* 0.5 

0.5 for 50% 

sponsor donations is the name of the new field and box office receipts is where the info is being compared from

Answer 2

Yes I realized that after sorry. I had the same homework assignment, that was the answer to achieve the correct result in the query. I was trying to figure out why, but I see now. Thank you

Answer 3

So again, why are you using a Group By query when there no aggregates being done. I can understand if you wanted to sum the receipts by concertID or and Sponsor Name. But you don't have a sum field. So there is no reason for a Group By query.

Shanna, I just realized that your question is piggy backed on a 2 year old thread. Please use the Participate link above to start your own thread and when you do so, please detail your exact problem.

Answer 4

Why are you using a Group By query when you have no aggregate field? What exactly is the query trying to show?

Answer 5

Yes I have searched and I don't know if this program is just having issues (It has done that multiple times to me) or if it's me doing the querie incorrect.  The one I circled is the one I am trying to add that is not cooperating with me.