I am making a table based on a Crosstab query. The possible fields are 1, 2, 3, 4.
If the crosstab query does not come across any 4's then the resulting table will only show 1, 2, 3.
The problem is, the subsequent queries based on the crosstab query looks for a value for 1, 2, 3, 4. (even if blank).
So after the cross tab query makes the table, I need to add any 'empty' fields to the table if it dosn't already exist.