Looks like we're gonna have to start a sitcom section you and me .

He didn't specify he was using sql server for this project .

No it's nice... good things you don't have boxer shirts and pants to go with that .

Sometimes you have to look around the error to actually find it .

Remove the part in red

update dbo.mci_geocodable set zipcode_2 = left(zipcode_2,9(zipcode_2) - 4) where right(zipcode_2,4)='0000'

Because I wasn't assuming that there was only us zip codes .

It's hard to tell when you don't have all the info...

Admin to do what exactly?

"Remi, your religious insistence on moving the job to the server is misguided. You remind me of the saying, "To a man with a hammer the world looks like...

Sorry but that offer doesn't stand for me... I actually supported you guys and bought all the books so I won't be a suck-up now and try to get another...

One other thing... Make sure that the bookmark variable is of variant type. I've had problems when I set it to int sometimes.

What's the advantage? Does the server perform a delete from table before the drop?

Please paste the exact statement you are using. My statement works right away (besides the foridden use of the reserved works table and column). It's most likely a simple...

What statement are you using?

The bookmark property can work, but if a record is added in font of the selected row and you refresh, then the bookmark won't be pointing back to the correct...

Forgot to post this link for an all-access forum :

http://www.AccessMonster.com