One thing you could do is keep a running counter. Set it to 1 initially,
and start your loop. If you're not on the first row of the loop (i.e.
currentrow NEQ 1), and the current row's manufacturer doesn't match the
previous row's manufacturer (i.e. queryname.manufacturer[currentrow] IS NOT
queryname.manufacturer[currentrow - 1]), reset the counter to 1, and do a
linefeed (i.e. going from Broad Bay to Brown Sheep) - otherwise, increment
it one.

As you loop over and spit out the brands, if the counter is even (counter
mod 2 EQ 0), do your extra linefeed.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to