I have created several crosstab queries to show data in my table but regardless of whether I choose month or qtr I see that the data shown is across all years (e.g. Jan is not split into 2006, 2007 but all years are added). I treied to change the query so the date format was mmm, yyyy but then when I ran it there was no data at all in the columns. Please help!
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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Crosstab query showing all years
- Thread starter shaunacol
- Start date
Assuming you have a date field in your query, you can set the column heading to something like:
If you want to display months where there is no data, you can enter all desired column names into the Column Headings property.
If you can't figure this out, come back with your current SQL view of the crosstab as well as what you are seeing.
Duane
Hook'D on Access
MS Access MVP
Code:
ColHead: Format([DateField],"yyyy-mm")If you can't figure this out, come back with your current SQL view of the crosstab as well as what you are seeing.
Duane
Hook'D on Access
MS Access MVP
- Status
Similar threads
- Locked
- Question
- Question
