Question: Delete the ServiceDate field from the Average By Month query. Add a new column using the Expression Builder. Create a formula to extract the name
Delete the ServiceDate field from the Average By Month query. Add a new column using the Expression Builder. Create a formula to extract the name of the month from the ServiceDate field using a combination of the Date part and MonthName functions. Name the column Month, and move the Month field to the left of the Numinparty field. Run the query. Save and close the query. Delete the ServiceDate field from the Average By Month query. Add a new column using the Expression Builder. Create a formula to extract the name of the month from the ServiceDate field using a combination of the Date part and MonthName functions. Name the column Month, and move the Month field to the left of the Numinparty field. Run the query. Save and close the query
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
