Reports :: Stop Subtotal From Adding Detail Lines

How to keep Access from including the detail line items in my report total?

Below is a quick image of part of the report.

The report is compiled from two tables. The first table has detail information on each line, in four columns:

State Name Amount Quantity (Not used)

AL Store 1 313.94 60
AL Store 2 12.59 1
AZ Store 3 576.45 90
CO Store 4 172.22 24
CO Store 5 502.25 88

The 2nd table is a summary by state with three columns:

State Amount Quantity (Not used)
AL 326.53 61
AZ 576.45 90
CO 674.47 112

I'm trying to make the report group by state, then name, amount and a subtotal for each state. This all works fine in the report.

I want to also add the amount field from the 2nd table (State Subtotals) to the report just for reference. I've managed to make this work as well. (See State Total on image)

The problem that I'm having is that when I try to do a final total of the State Total column in the report footer, it seems to add the (State Subtotals) amount field on every detail line (See red numbers in picture. they are not actually on the report, but Access thinks they are and includes them in the final total).

So far I've tried different joins, hiding various fields, sub reports, ect. I just can't figure out how to stop Access from calculating the detail lines.