I'm trying to create a sub-form from a crosstab query which displays a projects costs (by project) against the staff working on it (column heading). Different projects have different staff members so therefore no fixed columns. I'm getting the message about 'not being able to use a pass thru query on a non-fixed column cross-tab query....'.
I don't want to fix the columns names because different projects have different staff members.
Does anyone have any suggestions?