P Phil Hunt Jan 27, 2004 #1 Does any one have some sample for making a report from a crosstab query ?
P Paul Overway Jan 27, 2004 #2 Really there isn't any difference in the report. But the crosstab query must have fixed columns. See help for the ColumnHeadings property.
Really there isn't any difference in the report. But the crosstab query must have fixed columns. See help for the ColumnHeadings property.
P Phil Hunt Jan 27, 2004 #3 the difference is you cannot create a report that can run again *any* resulting crosstab
P Paul Overway Jan 27, 2004 #4 If the crosstab doesn't have fixed columns...that is correct. But that isn't a problem with the report...it is a problem with the programmer. ;o)
If the crosstab doesn't have fixed columns...that is correct. But that isn't a problem with the report...it is a problem with the programmer. ;o)
D Duane Hookom Jan 29, 2004 #5 Check the sample crosstab reports at http://www.invisibleinc.com/divFiles.cfm?divDivID=4
A Alex Dybenko Jan 31, 2004 #6 if you have access 97 - you can find a sample in solutions.mdb sample database