Crosstab query of monthly account totals

[chasew]

Right now I have a crosstab query sorting expenses by Budget Section and Month. I want to make it show only one line for each Budget Section with a total each Month. The data is pulled from a Transactions table which has ID, Date, Cost, Budget Section and some other fields not relevant to this query. In total there are 19 Budget Sections I will have lines for in the query. What's the easiest way to make this work?

What I have:

Section	2015-07	2015-08
Gas	$23.48
Gas	$56.62
Gas	$20.00
Gas		$33.65
Gas		$41.81
Gas		$46.93
Parts	$83.74
Parts	$31.46
Parts	$14.54
Parts	$19.79
Parts	$12.37
Parts		$5.93
Parts		$341.71

What I want:

Budget Section	2015-07	2015-08
Gas	$100.10	$122.39
Parts	$161.91	$347.64

Thanks

[June7]

A crosstab query should show only one line for each budget item unless you have some other field as another RowCriteria. Since you don't show any other fields, I don't understand why there are multiple lines for each budget item.

Review http://allenbrowne.com/ser-67.html

[chasew]

I reopened the database after dinner and now it works. I don't know what changed when I closed it but the crosstab runs as I wanted it to now.