[AccessD] Reformatting a table's data

Drew -

I'm using Access2000.

I looked up the Split function, but am a bit confused.

Do you have an example of this?

 

Thanks,

Mark

 

-----Original Message-----
From: Drew Wutka [mailto:DWUTKA at marlow.com] 
Sent: Wednesday, February 05, 2003 2:08 PM
To: 'accessd at databaseadvisors.com'
Subject: RE: [AccessD] Reformatting a table's data

 

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/72109159/attachment-0002.html>