Re: Separating Fields in Access
- From: Klatuu <Klatuu@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 16 Oct 2007 11:18:00 -0700
Open the table in design view and add the two new fields.
Then create an update query that will update both fields
For Number it would be:
Left(TrackingNumber,6)
For Indicator it would be:
Right(TrackingNumber,1)
Open the table in design view and delete the original TrackingNumber field.
--
Dave Hargis, Microsoft Access MVP
"Hendrix10@xxxxxxxxx" wrote:
On Oct 16, 1:08 pm, fredg <fgutk...@xxxxxxxxxxxxxxx> wrote:.
On Tue, 16 Oct 2007 16:57:52 -0000, Hendri...@xxxxxxxxx wrote:
I have a table that I imported into Access. I would like to separate
on of the fields into to two separate fields. The field that I want to
separate is a total of 7 characters and i would like to break it up
into one field of 6 and another of 1. Is this possible? If so, how is
it done?
H
How are we to know which of the 7 characters goes where?
You might start by giving us an example or two of what the data looks
like and what result you would like to see.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
The original field is "traking number" and the data in the field
looks like 123456A.
I would like the "Traking Number" to be broken up into two fields
"Number" (which would be 123456) and "Identifier" (which would be A).
Hendrix
- References:
- Separating Fields in Access
- From: Hendrix10
- Re: Separating Fields in Access
- From: fredg
- Re: Separating Fields in Access
- From: Hendrix10
- Separating Fields in Access
- Prev by Date: Re: Separating Fields in Access
- Next by Date: Re: Access 2007 Runtime vs Program on same PC
- Previous by thread: Re: Separating Fields in Access
- Next by thread: Re: Separating Fields in Access
- Index(es):
Relevant Pages
|
