Search results

I created a crosstab query to give me the aggregate totals for each of my 10categories over 3 years. Categories going down, years going across. However when I try to create a report and sum the 3 years I don't get a true sum it adds the fields togethers. Example. 2004 - 0 2005 - 1850 2006 - 0...

I haven't used Access for a few years and am trying to create the following in a report. I need a by state report - so 50 pages. I want to list 3 years worth of data and a 3 year combined total. So 4 columns of data total. I have 12 categories that may or may not have data for those 3 years...