In Access, In the query, add a calculated field to the SELECT clause that multiplies the Rate and Hours fields from the HourlyFees table. Set the caption for the calculated field as Total. Add a SQL aggregate function to the calculated field to calculate the total of the Rate field multiplied by the Hours field.

here is what I have and it is telling me I am missing the last sentence in the question.

SELECT Lawyers.FName, Lawyers.LName, Sum([HourlyFees]![Rate]*[HourlyFees]![Hours]) AS Total