[AccessD] Reformatting a table's data

Drew Wutka DWUTKA at marlow.com
Wed Feb 5 13:09:00 CST 2003


Sounds like the split function is what you want.  What version of Access are
you using.  97 doesn't have the split function.
 
Drew

-----Original Message-----
From: Mark Boyd [mailto:MarkBoyd at mcbeeassociates.com]
Sent: Wednesday, February 05, 2003 12:53 PM
To: AccessD at databaseadvisors.com
Subject: [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/5e2f4295/attachment-0002.html>


More information about the AccessD mailing list