You can't calculate totals on the asterisk (*).@Because the asterisk represents all the fields in the table, you can't calculate ...

You can't calculate totals on the asterisk (*).@Because the asterisk represents all the fields in the table, you can't calculate totals on it.@Remove the asterisk from the query design grid. Add the fields you want to use to the design grid, and then select the total you want to calculate for specific fields.@1@2@11202@1