I need help writing a Query in Microsoft Access.

 

The Query is for a 'Dance Marathon Database' and needs to meet the following criteria: 

 

QUERY 5
An anonymous donor is willing to give $10 for each hour that each team dances at the marathon. Create a query that displays each team name and the date(s) they are dancing and then calculates the additional donation. The additional donation should be the number of hours each team dances multiplied by 10. Display the results so that the largest donation is shown at the top of the query; format the Additional Donation column as shown. Save the query as Additional Donations.

I have attached the database itself to make it easier to see what the question is asking for.

• 1500567735-Database.zip

APlusGrades

Not Rated (0)

Status NEW Posted 20 Jul 2017 04:07 PM My Price 12.00

Hel-----------lo -----------Sir-----------/Ma-----------dam----------- Â-----------  -----------Tha-----------nk -----------you----------- fo-----------r u-----------sin-----------g o-----------ur -----------web-----------sit-----------e a-----------nd -----------acq-----------uis-----------iti-----------on -----------of -----------my -----------pos-----------ted----------- so-----------lut-----------ion-----------.Pl-----------eas-----------e p-----------ing----------- me----------- on----------- ch-----------at -----------I a-----------m Â----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I

Not Rated(0)

• Buy Answer