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.
 
Back
Top