Another parsing question 1

[vbahelp07]

Hello everyone!

I have the following question / issue.

i need to parse out the 3 letter ArtistCodes as some items have more then one Artist that designed the item.

I am using the following at the moment:
1stArtist: Left([DB_UDF_IMH_ARTIST],InStr([DB_UDF_IMH_ARTIST],".")-1)

and getting this as the result:
1stArtist DB_UDF_IMH_ARTIST
#Error MMF
MMF MMF.DRG
MMF MMF.DRG
MMF MMF.DRG
MMF MMF.EAC
MMF MMF.SNS
MMF MMF.SNS

ok, the question / issue on what I am trying to do.
I need to show the ArtistCodes as they were inputted BUT also separate the codes out as their own record.
this is so that the total per Artist can be calculated.

MMR.DRG means both MMR and DRG Artists designed an item.

MMF.DRG	VHW003 $657.96

MMF VHW003 $328.98
DRG VHW003 $328.98

i hope I made sense here ...

 

[vbahelp07]

dhookom,
you are so patient!

thanks a million!

 

[lespaul]

you may find the following article helpful:

Understanding SQL Joins

Leslie