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 biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: TMcGuireFCC
- Order by date
-
Cross Tab - Rank Query? Help
thank you all for your help. Yes it takes forever to make the table, but it workled after removing that last (. I guess it is time to teach myself SQL.....- TMcGuireFCC
- Post #10
- Forum: Microsoft: Access Tables and Relationships
-
Cross Tab - Rank Query? Help
still does not like it. a number field does not need the [] or "" BUT a text field does? and why all the extra "s? I am in Access 2003, not 07 - does that make a difference?- TMcGuireFCC
- Post #7
- Forum: Microsoft: Access Tables and Relationships
-
Cross Tab - Rank Query? Help
Client_ID is a number field.- TMcGuireFCC
- Post #5
- Forum: Microsoft: Access Tables and Relationships
-
Cross Tab - Rank Query? Help
Duane, hmmm... Unless I am missing something, it did not work. Primary field is Clients_ID and Serv1name is the servicer field name. It is telling me that I have a syntax error in the PIVOT clause. TRANSFORM first([Policies Active Today Servicers].serv1name) AS firstofserv1name SELECT...- TMcGuireFCC
- Post #3
- Forum: Microsoft: Access Tables and Relationships
-
Cross Tab - Rank Query? Help
I am seeing lots of questions about this, and someone said to search based upon "Rank Query" but I cannot find one. I am good at Access, but not the SQL behind the scenes. I have a large list of Clients, where each client has from 1 - 10 Service People. I need a cross-tab-like query that...- TMcGuireFCC
- Thread
- Replies: 9
- Forum: Microsoft: Access Tables and Relationships
