B
Brenda @ AIM
I have two problems in a crosstab query.
I have 7 kit numbers grouped by state. I add each kit total for each state.
In design view my query looks like this:
State Kit# Count Dates
In datasheet view it comes out like this:
State Kit#1 Kit #2 Kit#3 Kit#4 Kit#5 Kit#6 Kit#7
(these are totaled from original table)
I need another column that totals all the kit number totals(which is [count]
in the design view). Also I have nulls that need to be changed to zeros.
My problem is that in design view I only have one fieldname for the amounts
(count).HELP
I have 7 kit numbers grouped by state. I add each kit total for each state.
In design view my query looks like this:
State Kit# Count Dates
In datasheet view it comes out like this:
State Kit#1 Kit #2 Kit#3 Kit#4 Kit#5 Kit#6 Kit#7
(these are totaled from original table)
I need another column that totals all the kit number totals(which is [count]
in the design view). Also I have nulls that need to be changed to zeros.
My problem is that in design view I only have one fieldname for the amounts
(count).HELP