THen add a counter that increments for each detail record. Base the criteria on the counter.
>I'm not sure how to get the record number. I'm using visual basic 6.0, I have a SQL statement/object in vb data environment which is bound to the crystal report that I'm doing. I understand how to change the colors but not on how to get the record number. Should I maybe put any alias in the sql statement to count and then based on that number do the color change that I want to do?
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer