Update Query to 'strip' - not working in Office 2007??
- From: Doc <pc-dc-doc@xxxxxxxxx>
- Date: Wed, 13 Jun 2007 14:59:35 -0700
Hi there,
Have a large SQL file with a field (Name) which has the first and last
name separated by a ~ . I want to 'strip' out the first and last name
into their own fields.
I went into the TABLE and 'added' fields of 'FirstName' and 'LastName'
and also Organization (about 100 entries are not names but Companies)
and then used a previously successful query (as follows):
It is an 'update' query - or so it seems from what I understand about
2007 Access.
Under FirstName in the UPDATE TO cell enter the formula
TRIM(Left([tblName].[FieldName],Instr(1,[tblName].[FieldName],"~")))
UnderLastName enter the formula
TRIM(MID([tblName].[FieldName],1+Instr(1,[tblName].[FieldName],"~")))
Under the FieldName in the criteria enter Like "*~*"
Select Query: Run from the menu
When I run it, a PROMPT asks for a 'parameter' entry for the
tblname:fieldname and I'm not sure how to answer that - I believe that,
even though this worked in 2003 (no longer available) I'M DOING
something wrong here.
Appreciate any and all help. Thank you.
Doc
.
- Prev by Date: RE: New and Not Sure Where to Start
- Next by Date: Re: New To Access and having trouble with synchronized fields
- Previous by thread: RE: New and Not Sure Where to Start
- Next by thread: Re: Update Query to 'strip' - not working in Office 2007??
- Index(es):
Relevant Pages
|
