asked on Producing a Report from Crosstab query
A similar question has been asked several times before, but none have quite answered mine sufficiently.
I have an Access crosstab query which is used to produce a Report. The problem is the columns that the query produces are different each time. The report needs to know which columns to expect, but it's impossible to know.
Is there a way around this?
I have an Access crosstab query which is used to produce a Report. The problem is the columns that the query produces are different each time. The report needs to know which columns to expect, but it's impossible to know.
Is there a way around this?
Microsoft Access
Last Comment
Jeffrey Coachman
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
This is because this is not inherently an easy thing to do...
So I am not sure any posts here will make this any less painful...
;-)
JeffCoachman