mrchonginhk
Well-known Member
- Joined
- Dec 3, 2004
- Messages
- 679
I have a mdb table like this
Name Date Duration
========================
Paul 25-Jul-08 PM
John 26-Jul-08 Full Day
How can I turn it into this using SQL?
Name 25-Jul-08 26-Jul-08
=====================
Paul PM
John Full Day
Pls help. Thanks.
Name Date Duration
========================
Paul 25-Jul-08 PM
John 26-Jul-08 Full Day
How can I turn it into this using SQL?
Name 25-Jul-08 26-Jul-08
=====================
Paul PM
John Full Day
Pls help. Thanks.