Recent content by JasTa84

Thanks Sportsguy. I've never used VB code in the query builder, could you post a more detailed example of how this can be done? If I wanted to use the cross-tab format, is there a way to use Dsum to calculate the 12-month rolling total? Thanks

Hello, I have a cross tab query with state as a row header and the first day of the month as a column header. This covers 3 years. As a value I have a cost. Instead of showing the cost for each month (ie March 2009 only) I would like to see the 12 month rolling total under each month (ie...