Separating Fields in Access

H

Hendrix10

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
 
F

fredg

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
Click to expand...

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.
 
H

Hendrix10

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.
Click to expand...



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
 
K

Klatuu

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.
 
F

fredg

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
Click to expand...

Dave gave you the correct method.
 
H

Hendrix10

Dave gave you the correct method.

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail- Hide quoted text -

- Show quoted text
Click to expand...

I followed the direction and it broke up the work "Tracking Number"
but not the values in the "Tracking Number" column. Is that what was
supposed to happen? If so, is there a way to break up the values of
the Column? If not, what might I have down wrong?
 
J

John W. Vinson

I followed the direction and it broke up the work "Tracking Number"
but not the values in the "Tracking Number" column. Is that what was
supposed to happen? If so, is there a way to break up the values of
the Column? If not, what might I have down wrong?
Click to expand...

You probably put "Tracking Number" in quotes, or Access added the quotes for
you, rather than using [Tracking Number] in square brackets, to indicate that
it's a fieldname.

If this doesn't help, please open your query in SQL view, by clicking View...
SQL on the menu while the query is open in design view. Copy and paste the SQL
text to a message here.

John W. Vinson [MVP]
 
H

Hendrix10

I followed the direction and it broke up the work "Tracking Number"
but not the values in the "Tracking Number" column. Is that what was
supposed to happen? If so, is there a way to break up the values of
the Column? If not, what might I have down wrong?
Click to expand...

You probably put "Tracking Number" in quotes, or Access added the quotes for
you, rather than using [Tracking Number] in square brackets, to indicate that
it's a fieldname.

If this doesn't help, please open your query in SQL view, by clicking View...
SQL on the menu while the query is open in design view. Copy and paste the SQL
text to a message here.

John W. Vinson [MVP]
Click to expand...

That was it.

Thanks

Hendrix
 
Top