I have a bit of a problem with a crosstab query. Ive set up a crosstab query to COUNT the number of occurances of a certain critereia, in 2000,2001,2002, etc. My column headings are the year and my row headings are a category. if there are no occurances of that category within a year, the query just shows a blank/null field. When I subsequently create a report from this, the txtbox bound to the query field with a null value obviously shows nothing. The problems is, when I add a "Totals" column to the right hand side of the report, if one of the preceeding fields is null it will not total and of the columnss...any ideas how to get around this?