Start each report on an odd page

I have a query which list 500 users each user has 2 or 3 page report.
How do I make each report start on an odd page?
I am running Windows NT with Access 97

I see you did somethin for Access 2000 but couldn't relate this to my 97 report

Can you explain a little more by "odd" page. Are your reports being run on two sided sheets so you always want the beginning of each users report to be on the front side of the sheet? And page numbers, are these to be consecutive numbers or do you want each users report to restart with 1?

lwells

You got it I always want to start on the front of the sheet.
I have managed to get the page nos to be one for the start so I am just missing something easy I hope

I will have to apologize, I didn't see your reply from a few days ago. Okay first things first, Access won't allow a blank page in your reports between records. So what you will have to do is create a recordset of the records or use a query and send each record one by one to the printer. That way each record will always begin on the front side of the paper. Something along these lines might work...I haven't tested so you will need to try it out as I don't have Access 97 on my machine. And you might need to change the syntax slightly for use with Access 97 as well.

This example is using a query named YourQuery for the recordset and UserID as the Primary Key for the records.

Dim rst As Recordset
Set rst = CurrentDb.OpenRecordset("SELECT UserID FROM YourQuery")
With rst
Do Until .EOF
DoCmd.OpenReport "YourReport", , , "[UserID]=" & ![UserID]
.MoveNext
Loop
.Close
End With
Set rst = Nothing

Give it a shot and let me know.

lwells