Where did I go wrong in this formula?

[alexalodo]

I'm trying to finish up an Access homework and so far have done okay, but now I'm stuck on a question because it asks me to enter a parameter value when there is no mention of parameter value in the instructions...What am I doing wrong this time? I shouldn't have to enter a "parameter value", the instructions don't mention parameter value, I think I did something wrong. Please help. Instructions and screenshot are included below.



Instructions:
Create a query in Query Design view based on both tables to answer the question, What is the Concert ID, Sponsor Name, Box Office Receipts, and a new field named Sponsor Donation that will calculate and display the donation amount when the Sponsor donates an amount equal to 50 percent (0.5) of each box office receipts amount to the Music Department. Sort the records in ascending order by the Concert ID field. a. Run the query (the second record—EVENT-102—has a Sponsor Donation of 287.5).


I input concert ID, Sponsor name, box office receipts and I right clicked the next column to go into "Build" and I put in this: Sponsor Donation: [Amount]*0.5 then pressed OK, clicked run and this is the message that I get. I press cancel because I do not want to enter a parameter value, but it does nothing. Am I doing something wrong?

[CJ_London]

looks like you don't have a field called amount

[ssanfu]

What table is the field Amount in??

Hint:

...display the donation amount when the Sponsor donates an amount equal to 50 percent (0.5) of each box office receipts amount ...

Two other issues are
1) "Date" is a reserved word in Access and shouldn't be used for object name.
2) You have spaces in object names.



And welcome to the forum....

[pdanes]

When you refer to a field name that is not defined in any of the sources, Access will ask you for a value for that field.

In the fourth column, you have: [Amount] * 0.5

but there is apparently no field named Amount in either of the source tables, so Access asks you what it should be. This is a feature, that you can set up a query that will collect information from tables or queries, and you can also enter an additional parameter manually. This allows you to make a query that can interact with the end user, or with code, if you call the query from VBA.

You've hidden the Sponsors table behind the parameter request, so I can't guess what the field names there might be. What fields did you want to use to compute the Sponsors Donation value?