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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Using a separate sort column works in query, but doesn't transfer to pivot table or chart view
Yes, I think I will have to do that. I'd rather not not have to, but after researching more, it seems to be the only option. Another thing I am trying is I exported the query into Excel, as it has a few more chart options.- uwrijc
- Post #5
- Forum: Microsoft: Access Queries and JET SQL
-
Using a separate sort column works in query, but doesn't transfer to pivot table or chart view
Hello, I have a query that shows age ranges, e.g.: 0-17mo 18mo-3yrs 4-5yrs 6-10yrs 11yrs I created a sort column (age1; age2; etc.) so they are returned in the correct order, and not: 0-17mo 11yrs 18mo-3yrs etc. I am setting this in the sort row of design view. It works fine when I run...- uwrijc
- Thread
- Replies: 5
- Forum: Microsoft: Access Queries and JET SQL
