How can I create two records from one?

[Guest]

I have a field record that contains two sets of information separated by a
comma in a table that is used for a custom software; in other words, I can
not change the table or else the software will no longer work. I need to
extract the information from that field and create two separate fields from
that.

How do I do that???

 

[Guest]

Try this --
Field1: Left([OldField], InStr(",",[OldField])-1)
Field2: Mid([OldField],",")

 

[Guest]

Karl, can you elaborate in this?

1-I am working with a queire.
2-Where does this entry go exactly? Criteria?
3-Do I enter it exactly as it is and replace only "Oldfield"?

Try this --
Field1: Left([OldField], InStr(",",[OldField])-1)
Field2: Mid([OldField],",")

I have a field record that contains two sets of information separated by a
comma in a table that is used for a custom software; in other words, I can
not change the table or else the software will no longer work. I need to
extract the information from that field and create two separate fields from
that.

How do I do that???

 

[Guest]

Open the query in design view and add new columns as show for Field1 and
Field2 substituting your field name for "Oldfield" and a column label to suit
your needs.

Karl, can you elaborate in this?

1-I am working with a queire.
2-Where does this entry go exactly? Criteria?
3-Do I enter it exactly as it is and replace only "Oldfield"?

Try this --
Field1: Left([OldField], InStr(",",[OldField])-1)
Field2: Mid([OldField],",")

I have a field record that contains two sets of information separated by a
comma in a table that is used for a custom software; in other words, I can
not change the table or else the software will no longer work. I need to
extract the information from that field and create two separate fields from
that.

How do I do that???

 

[Guest]

Karl,

In design view to the left I have the titles Field, Table, Sort, Show,
Criteria and Or. I am not understandign where I should put the specific
entries!

Open the query in design view and add new columns as show for Field1 and
Field2 substituting your field name for "Oldfield" and a column label to suit
your needs.

Karl, can you elaborate in this?

1-I am working with a queire.
2-Where does this entry go exactly? Criteria?
3-Do I enter it exactly as it is and replace only "Oldfield"?

Try this --
Field1: Left([OldField], InStr(",",[OldField])-1)
Field2: Mid([OldField],",")

:

I have a field record that contains two sets of information separated by a
comma in a table that is used for a custom software; in other words, I can
not change the table or else the software will no longer work. I need to
extract the information from that field and create two separate fields from
that.

How do I do that???

 

[Guest]

Karl,

I the row where it says Field I have written "Field1" I left all other
rows empty except for the "Criteria" row where I put in the formatting for
field1, and so on for Field2.

Once I switch to Datasheet view it prompts me to enter the parameter
value? What do I do?

Karl,

In design view to the left I have the titles Field, Table, Sort, Show,
Criteria and Or. I am not understandign where I should put the specific
entries!

Open the query in design view and add new columns as show for Field1 and
Field2 substituting your field name for "Oldfield" and a column label to suit
your needs.

Karl, can you elaborate in this?

1-I am working with a queire.
2-Where does this entry go exactly? Criteria?
3-Do I enter it exactly as it is and replace only "Oldfield"?

:

Try this --
Field1: Left([OldField], InStr(",",[OldField])-1)
Field2: Mid([OldField],",")

:

I have a field record that contains two sets of information separated by a
comma in a table that is used for a custom software; in other words, I can
not change the table or else the software will no longer work. I need to
extract the information from that field and create two separate fields from
that.

How do I do that???

 

[Guest]

If I understand right, you want to take a field in Table1 that has two sets
of information separated by a comma, split it at a comma and save the
results in two separate fields in Table2 ?

Is there one and only one comma in the data?

Would you post an example of the data?