mattichu Posted December 12, 2012 Share Posted December 12, 2012 (edited) Hi I have a table: ------------------------------------------------------------------------------------------ ID | DATE | Staff1 | Staff2 | Staff3 | venue | ------------------------------------------------------------------------------------------ 1 1st Jan 10-cl 11-cl OFF xx 2 2nd Jan 11-cl 10-cl 10-cl xx 3 3rd Jan 10-cl 11-cl OFF xx 4 4th Jan 11-cl 10-cl 10-cl xx 5 5th Jan 10-cl 11-cl OFF xx 6 6thJan 11-cl 10-cl 10-cl xy How would I swap the contents in staff 1 and 2 AFTER the 2nd jan? any help much appreciated! ^^ Edited December 12, 2012 by mattichu Quote Link to comment Share on other sites More sharing options...
Pikachu2000 Posted December 12, 2012 Share Posted December 12, 2012 Let me get out my crystal ball. Quote Link to comment Share on other sites More sharing options...
Jessica Posted December 12, 2012 Share Posted December 12, 2012 You need to normalize your data. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.