Separating Fields in Access

[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

 

[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

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.

 

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

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

 

[Guest]

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.

 

[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

Dave gave you the correct method.

 

[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

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?

 

[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?

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]

 

[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?

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]

That was it.

Thanks

Hendrix