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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by SPE2
-
Rows and Columns
My fault.. Missed out a table name, your code works fine both in mdb mode and Access Project mode with slight punctuation mods. I never expected to get this sorted this evening. I can now scale it up to my 500,000 rec problem Thanks again- SPE2
- Post #8
- Forum: Microsoft: Access Queries and JET SQL
-
Rows and Columns
Thanks PH, Looks good but it is not happy with the first Sum line as it doesn’t like the colour field not being summed. I think it may also need some other punctuation. I really do appreciate your time in looking at this SPE- SPE2
- Post #6
- Forum: Microsoft: Access Queries and JET SQL
-
Rows and Columns
Sorry, Nothing other than embarrassing failures to show I can’t seem to get away from the colour appearing multiple times- SPE2
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Rows and Columns
I new member to this Forum and the question is more a ADP / SQL question but any help is much appreciated. I have a table with multiple records that I need to reformat. Colour Size Qty Rec1 Red L 1 Rec2 Red M 2 Rec3 Red S 3 Rec4 Blue...- SPE2
- Thread
- Replies: 7
- Forum: Microsoft: Access Queries and JET SQL
