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!

Register Log in
  • Congratulations TouchToneTommy 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: SPE2
  • Order by date
  1. 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
  2. SPE2

    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
  3. SPE2

    Rows and Columns

    Sorry, Nothing other than embarrassing failures to show I can’t seem to get away from the colour appearing multiple times
  4. SPE2

    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...

Part and Inventory Search

Back
Top