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 MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Crosstab Query Column heading help
dhookom, Thanks for the suggestion, but that would still only give me one column of data. Based on my example, if I did that, I would get the MemberID as row header, the colunn header "A", and the First DOS. But what I need is a column header "A1", containing the Min DOS, then a column header...- maeza001
- Post #5
- Forum: Microsoft: Access Queries and JET SQL
-
Crosstab Query Column heading help
Yes, I have. This will only allow me to get Aggregate values such as Count, sum, min or max for the the [DOS] value and will only give me the Group By option for the column heading [svctype]. So if I use count of [DOS] I end up with: MemberID A 123456 4 234567 2 I'm doing this because...- maeza001
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Crosstab Query Column heading help
I need to create a crosstab query in Access 97 that will basically move data in different rows to multiple colums in the same row. Each [MemberID] has multiple dates of Service ([DOS]) for a particular type of service ([svctype]), such as "A", "B", etc.. I want to create a crosstab that will...- maeza001
- Thread
- Replies: 5
- Forum: Microsoft: Access Queries and JET SQL
