Open the TotalFees query and add a calculated field that sums the RegistrationFee field values and the AnnualFee field values. Assign the allas TotalFees to the calculated field. Save the query.

Create a parameter query for the Members tabje that will allow the user to enter a different state each time the query is run. The user should see all fields in the query result. Use Enter desired state as the input prompt. Save the query using Memberstates as the query name.