One Field to Many

  • Thread starter Thread starter Cheryl
  • Start date Start date
C

Cheryl

I currently have a field in my Access97 database called "Charges." It
is a text field with entries entered like this: "RD/DWI/Eluding/BAR."
The key field is the CaseNumber field (like 99-369 below).

I'd like to make a separate table for "charges" and break it down to one
record for each charge. Like this:

TblCharges:

CaseNumber Charge
99-369 RD
99-369 DWI
99-369 Eluding
99-369 BAR

What would be the best way to do this?

Cheryl
 
You can write a VBA procedure to step through the characters, parsing out
words that exist between each "/"

Instr(), Left$(), and Mid$() can all be used to help you.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Assistance with Many-to-Many Relationships 4
Complicated Calculated Field Logic 0
Itereate cross tab query over another query 0
Update field (multiple criteria and updates) 5
Calculate values using criteria in multiple tables? 2
Moving multiple data to new fields 1
Two one to many's on one table 1
Separating carriage return data into separate cells 2

Back
Top