Access 2000 Database - Moving Data

  ihbuk1 10:50 13 Dec 2006
Locked

I have imported data into a database and I want to move Post Code information from certain fields into another field called Post Codes. The problem is that the initial Fields also contains information that needs to remain. The Post Codes all begin with “NE”. Any advise would be gratefully appreciated.

  Crunchy 12:10 13 Dec 2006

Look at the tutorial for Instr() function in Advanced Query Tips click here then use this principle in an update Query to populate your post code field.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

OnePlus 5 review

Alice Saey's mesmerising animation for Dutch singer Mark Lotterman

iPad Pro 10.5in (2017) review

Comment booster votre iPhone ?