Need a script but dont know where to start?

[scottee1988]

ok, i have a database with 2000+ records that i need to amend and update, the database obviously is in access, and i need a script that will save me a weeks worth of work.

what i want the script to do:

the database is basically to kep records of clients contact details, such as "Name" "Type of business" "Address" "DOB" "Post CODE"

i have created new fields within the base titled:

"1st line" "2nd Line" "Town" "county"

what i want to do with the script is to EG:

"32 the Leam, The Grange, Daventry, Northants" is written all in that 1 address field, i want the script to take "32 the Leam" cut it, and paste into 1st line, take "The Grange" and cut and paste into 2nd, then take "daventry" cut and put in town, and take "northants" cut n put in county,

needs to do that with 4000+ records, however, not all records have a 2nd line so is it possible to skip that? thanks

 

[PHV]

I guess you want to use an UPDATE query?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[HarleyQuinn]

And probably a user defined function to correctly break up the address?

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

http://lessthandot.com