need help creating a query

[nikki28]

My instructions are as follows:

"In the fourth column of 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 percent (0.5) of each box office receipts amount to the Music Department."

I put this - Sponsor Donation: [box office receipts]*(0.5)
however I keep getting a parameter vALue box popup. and cant get the correct results please help!

 

[plog]

2 things:

1. The parameter box is probably occurring because [box office receipts] isn't a field in the data source(s) the query is built on. My guess is you are calculating [box office receipts] and then trying to immediately use it in the same query. You can't do that. You would need to build another query that uses this query, then you can use [box office receipts] in a calculation .

2. Your instructions include the term 'when'; that's a conditional word. Which means you have to test something to see if it meets your conditions. That mans you're going to need an IIf function somewhere. Right now you're doing the calculation for everything, that's not right.

 

[nikki28]

I have no idea what im doing and I been stuck for two hours, this makes no sense whatsoever!

 

[nikki28]

Create a query in Query Design view based on both tables. Add the following fields to the design grid in the order given: Concert ID, Sponsor Name, and Box Office Receipts. Sort the records in ascending order by the Concert ID field. In the fourth column of 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 percent (0.5) of each box office receipts amount to the Music Department. Run the query (the second record—EVENT-102—has a Sponsor Donation of 287.5).

 

[nikki28]

please help I been stuck for so long

 

[AlexN]

My instructions are as follows:

"In the fourth column of 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 percent (0.5) of each box office receipts amount to the Music Department."

I put this - Sponsor Donation: [box office receipts]*(0.5)
however I keep getting a parameter vALue box popup. and cant get the correct results please help!

From the description given, it seems that the expression you made for the Sponsor Donation must be in the criteria field of this column. But I can't figure out what's to calculate. Uploading the tables would make it much easier.