I have a table that has event_id, event_title, capacity. I want to produce a report that outputs:

(EVENT ID) EVENT TITLE
______
______
______
______

(NEXT ID) EVENT TITLE
_____
_____
_____
_____
_____

where the number of lines below each event is determined by the value of the field capacity. I am assuming I do a x=x+1 loop but don't know how to apply this to a Report in VB.

Any help appeciated
Cheers
Steve