create new field with continuos number field

[ProgramError]

Hi All

having trouble making a report show only three records per page (using it to show three pairs of student names on a DVD so cannot alter report size or margins etc) so I thought I could do it by creating a colomn with a value of 1,2 or 3 then starting again at 1 ,2 then 3 again.

What I need to know is how can this be done in SQL?? totally confused tring to think of a method. I can do it on a form but cant on a report.


Ian Mayor (UK)
Program Error
Always make your words sweet and nice. Because you never know when you may have to eat them.

 

[PaulBricker]

On the report you can just add a counting field by putting =1 in the Control Source and setting the Running Sum property to Yes. Then in the Format event for the section the info is in, usually Detail, you can put code like this

If [FieldName] Mod 3 = 0 Then
"Force your page break here"
Else
End If

Paul

 

[PaulBricker]

That should be

If [CountingFieldName] Mod 3 = 0


Paul