>Your correct!
>
>This is the example:
>
>>>Name..Box..Media..Title
>>>Jane...1....CD.....A
>>>Jane...1....CD.....B
>>>Jane...2....CD.....C
>>>Jane...3....TAPE...A
>>>Joe....1....CD.....A
>>>Joe....2....CD.....B
>>>Joe....3....TAPE...A
>>>Joe....3....TAPE...B
>>>Joe....4....TAPE...C
>>>Joe....4....DISK...A
>
>My table looks more like this. :-)
>
>Name..Box..Media..Title
>Jane...1....CD.....A
>Jane...1....CD.....A
>Jane...1....CD.....A
>Jane...1....CD.....B
>Jane...2....CD.....C
>Jane...3....TAPE...A
>Jane...3....TAPE...A
>Jane...3....TAPE...A
>Joe....1....CD.....A
>Joe....2....CD.....B
>Joe....3....TAPE...A
>Joe....3....TAPE...A
>Joe....3....TAPE...A
>Joe....3....TAPE...B
>Joe....4....TAPE...C
>Joe....4....DISK...A
Ah, I see. So there are lots of repeated records.
BTW, you can allign the data better (in your messages) if you use a fixed-width font. This is done most easily with the HTML tag < PRE >. Like this (click on "Reply" to see the source code of the message):
Name..Box..Media..Title
Jane...1....CD.....A
Jane...1....CD.....A
Jane...1....CD.....A
Jane...1....CD.....B
Jane...2....CD.....C
Jane...3....TAPE...A
Jane...3....TAPE...A
Jane...3....TAPE...A
Joe....1....CD.....A
Joe....2....CD.....B
Joe....3....TAPE...A
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
