Re: Access 2003: How to split one (lastname, firstname) field into 2?
- From: "Rick B" <Anonymous>
- Date: Mon, 26 Jun 2006 08:52:07 -0500
You are trying to insert the XX left digits in your first name field? Don't
you have it backwards? Isn't the first name the right portion?
--
Rick B
"Carpediemlara" <Carpediemlara@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1FA43DBD-3273-4F49-8F42-40A746A93873@xxxxxxxxxxxxxxxx
I've been at this way too long! Syntax errors, type conversion
errors...help! I've tried ltrim/rtrim left/right...latest follows.
fullname
field is formatted "smith, john". from other postings I tried the
following
and now a type conversion error coming up...?
UPDATE [members test]
SET FirstName=Left([FullName],InStr([FullName]," ")-1)
WHERE ((([members test].FirstName) Is Null));
.
- Prev by Date: Re: Query breaks when adding new restriction
- Next by Date: Re: Access 2003: How to split one (lastname, firstname) field into 2?
- Previous by thread: Re: Finding partial matched duplicates across two fields
- Next by thread: Re: Access 2003: How to split one (lastname, firstname) field into 2?
- Index(es):
Relevant Pages
|
