Create a query in Query Design view based on the Events table. Add the following

Q: Create a query in Query Design view based on the Events table. Add the following

If you have any doubts, please give me comment... SELECT EventID, RentalFee, RentalFee*0.1 AS Donation FROM Events ORDER BY EventID;

ID: 3908699 • Letter: C

Question

Create a query in Query Design view based on the Events table. Add the following fields to the design grid in the order given: Event ID and Rental Fee. Sort the records in ascending order by the Event ID field. In the third column of the design grid, create a new field named Alumni Donation that will calculate and display the donation amount when the Alumni Association donates an amount equal to 10 percent (0.1) of each rental fee amount. Run the query (the first record—EVENT-1244—has an Alumni Donation of 150).

I have created the query and added the first two columns and criteria. I am stuck on the calculated field, I do not know how to create a calculated field and was hoping to get some instructions on how to do so.

Explanation / Answer

If you have any doubts, please give me comment...

SELECT EventID, RentalFee, RentalFee*0.1 AS Donation

FROM Events

ORDER BY EventID;

Navigate

Create a query in Query Design view based on the Events table. Add the following

Create a query that will replace the null for termdate in the workers table with

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.

Create a query in Query Design view based on the Events table. Add the following

Question

Explanation / Answer

Related Questions

Navigate