Hi All I need a little help here
I'm using MS Access 2000
I have a large table that I need to convert to loading up to my database system here
a simple example of what I'm looking to do.......
it's currently in format:
RefNo Surname Date1 Salary1 Date2 Salary2 Date3 Salary3
001 Jones 01/01 100.00 01/02 150.00 01/03 170.00
002 Peters 01/04 200.00 01/05 220.00 01/06 290.00
I need to keep the ref no and surname together but have all dates underneath in one column, and all salaries in the next, and possibly add the sequence no per member at this stage if possible eg:
Refno Surname Dates Salaries Seq no
001 Jones 01/01 100.00 1
01/02 150.00 2
01/03 170.00 3
002 Peters 01/04 200.00 1
01/05 220.00 2
01/06 290.00 3
etc
My knowlege of SQL is pretty basic but i pick up on it fairly quickly, I'm just not sure how to compile the string on this one!
Any help appreciated!
Cheers.