QuestionJuly 2, 2025

Task Instructions In Query Design view of the WorkshopsByType query, use the Expression Builder to create a calculated field that multiplies the CostPerPerson field by the MaxCapacity field as the last field in the query then run the query.

Task Instructions In Query Design view of the WorkshopsByType query, use the Expression Builder to create a calculated field that multiplies the CostPerPerson field by the MaxCapacity field as the last field in the query then run the query.
Task Instructions
In Query Design view of the WorkshopsByType query, use
the Expression Builder to create a calculated field that
multiplies the CostPerPerson field by the MaxCapacity
field as the last field in the query then run the query.

Solution
4.0(294 votes)

Answer

The calculated field `TotalPotentialRevenue` is added and displays the product of `CostPerPerson` and `MaxCapacity`. Explanation 1. Open Query in Design View Access the WorkshopsByType query and switch to Design View. 2. Add Calculated Field In the Field row of a new column, use Expression Builder to create the expression: `[CostPerPerson] * [MaxCapacity]`. 3. Name the Calculated Field Assign a name to the calculated field, such as `TotalPotentialRevenue`. 4. Run the Query Execute the query to view results with the new calculated field.

Explanation

1. Open Query in Design View<br /> Access the WorkshopsByType query and switch to Design View.<br /><br />2. Add Calculated Field<br /> In the Field row of a new column, use Expression Builder to create the expression: `[CostPerPerson] * [MaxCapacity]`.<br /><br />3. Name the Calculated Field<br /> Assign a name to the calculated field, such as `TotalPotentialRevenue`.<br /><br />4. Run the Query<br /> Execute the query to view results with the new calculated field.
Click to rate:

Similar Questions