Search results

Yep, you are right. I have the field as a text datatype.

Thank you Jon!!! This is exactly what I needed too!! My Nz function didn't have the '+0' so my crosstab query has been driving me nuts this week. Thanx a million.

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...

Yes, the Nz function now works!! Thanks ever so much. Now on to my percentages.

Let me try that and see if that fixes my '0' issue. For the percentages - do I need to calculate the percent of total in the query or report? I will probably need to break it down into two group totals - first 6 months - last 6 months. So each months percentage will be based on either Jan...

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...