push data to correct field with flag

[markbrum]

Hi,

I have an access database with a bad field structure e.g.:-

firstname - lastname - age - height
david - 25 - 6ft
mark - smith - 29 - 5ft10
collins - 34 - 5ft11
richard - jones - 6ft1

so some data is missing which is OK but where data is missing the remaining data is ranged left into the gap. I can put a flag in the data so I could put say 'SURNAME' before each surname but I would need some SQL to say when you see 'SURNAME' push the data into lastname field. Is this possible?

Thanks, Mark.

 

[traingamer]

You could count the delimiters (if the data has the '-' in it) and post accordingly.


traingamer