[AccessD] Reformatting a table's data

I have the following 3 records:

ClaimNo            ExceptionCodes

1                      1,2,3

2                      9,10

3                      1,11,20

 

What I am looking to do is reformat the table, so the records are easier
to work with.

I would like my result to look like this:

ClaimNo            ExceptionCode

1                      1

1                      2

1                      3

2                      9

2                      10

3                      1

3                      11

3                      20

 

Any ideas?

 

TIA,

Mark Boyd

Sr. Systems Analyst

McBee Associates, Inc.

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030205/68505668/attachment-0001.html>