How can I create two records from one?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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

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

Eddieduce said:
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???
Click to expand...
Click to expand...
 
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.

Eddieduce said:
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"?

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

Eddieduce said:
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???
Click to expand...
Click to expand...
Click to expand...
 
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!

KARL DEWEY said:
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.

Eddieduce said:
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"?

KARL DEWEY said:
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???
Click to expand...
Click to expand...
Click to expand...
 
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?

Eddieduce said:
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!

KARL DEWEY said:
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.

Eddieduce said:
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???
Click to expand...
Click to expand...
Click to expand...
 
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?
 
Back
Top