Getting sum for dynamic columns in crosstab query

[BatoBig]

Hi,
I have a problem I cannot resolve.
In database I have table showing invoices for fuel based on company cars ID and date of invoice.
Then I created crosstab query to show this data per months with all months sum for each car ID (like in attachment CrossTab Query result).
Then created a form with subform based on crosstab query showing dynamic columns for months (jan, feb,..etc), also based on some main form criteria.
What I need is to get totals for each month from this subform dynamic columns, so I can show them in report based on this subform.
Thanks

 

[MajP]

Below those columns in the footer put unbound controls. Then in each the control source is
=Sum([MonthNameHere])

 

[BatoBig]

Thanks,
that was solution.

 

[arnelgp]

you can make your Crosstab have a "fixed" (query Crosstab) column instead of dynamic.
then create another query (CrosstabSum query) that will sum each month total.
you can use Dlookup() on your report.