Crosstab missing data from original source

[mcranda]

I am wondering if there is a work around for my problem.

Currently a crosstab feeds off a table where the columns change with different data. For example, I have a column that is titled not aligned to truck route. When there is no criteria that fall in this column it is left off the of the table. I am trying to find an alternate way to maybe fix it in the cross tab vs. fixing it in the original table.

Is there a way to do this?

Thank you

 

[strive4peace]

yes

please post the SQL for your Crosstab query

also, do you have a table of truck routes? What is that table name? What is the name of the field containing the route name, and the name and data type of the fields to link?