Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Error Message?
- Thread starter herd
- Start date
In a crosstab query, the columns (the number of columns and what they are called) can change. Therefore you cannot use the results of a crosstab query as the basis for another query or of a report. Say the crosstab query first has a field called "MON" because the results have data for some Mondays in it. So you use the crosstab query results for another query. Then the next time you run it, you put in some date range and there is no "MON" results - then what will the query or report that is expecting "MON" supposed to do? Doesn't compute.
A solution is to set the Column Headings property of the query to something like "MON", "TUES", etc (if you will always want the same headings shown) this was it will make it "FIXED" columns.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at
A solution is to set the Column Headings property of the query to something like "MON", "TUES", etc (if you will always want the same headings shown) this was it will make it "FIXED" columns.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at
- Status
Similar threads
- Locked
- Question
