Hi,
I have developed a "Crosstab Query" based on an existing query. Works great...looks like:
Location
Date Canada U.S. Europe Asia
Jan 4 5 3 10
Feb 5 5 6 5
Mar 1 1 9 6
Now I would like to display this information(looking like the crosstab above)in a Report.
So I went into "Report" "New" "Report Wizard" and when I selected my crosstab query as the source of data the field list was empty.
How would I do this?
Thanks,
Kamille
I have developed a "Crosstab Query" based on an existing query. Works great...looks like:
Location
Date Canada U.S. Europe Asia
Jan 4 5 3 10
Feb 5 5 6 5
Mar 1 1 9 6
Now I would like to display this information(looking like the crosstab above)in a Report.
So I went into "Report" "New" "Report Wizard" and when I selected my crosstab query as the source of data the field list was empty.
How would I do this?
Thanks,
Kamille