I have an access database (DAO) as my datasource.
access database name is testdb
table name is responsetable
columns/variables are rsq01,rsq02 etc etc
the values in these columns range from 0-5.
I have a separate crosstabe for each column.
I can't seem to figure out what I need to do for each cross tab to eliminate it reading in the value 0.
do i need to create an sql expression for rsq01 then use it in the crosstab and what would an example of that expression be?