Ok, variation on a theme here relating to alternate shading of rows.
However in our data set we have clients who have one or many rows. In order to easier identify the blocks of rows for each client it’d be nice to have the shading alternate when the client ID changes.
Any thoughts? I guess it’d need to use the previous function in there somewhere
edit: actually fixed it but thought I’d post the solution I used in case it’s useful to anyone else.
Define a variable that uses previous function to determine change of value. 0=no, 1=yes
Define a running sum variable that adds up all the 1’s in the previous variable.
Use the regular method of shading alternate rows but use the running sum value created above instead of the row number.
norty303 
(BOB member since 2003-03-19)
(BOB member since 2002-09-19)