Hello All,

I have a list box with all of my pilots' names in it. And a text box that I put a month and year into and would like to print a report for every pilot I have on and his flight times for that month and year. I can do this no problem with the following code.

On Error GoTo Err_runQuery_Click

DoCmd.RunCommand acCmdSaveRecord
stDocName = "rptPerPilotCP"

DoCmd.OpenReport stDocName, acViewPreview, , "[tblDate by Month] = '" & mydate & "'"

DoCmd.Maximize


Problem is that when it opens the report I need each page to be an individual pilot. It is not doing that now however. Any words of wisdom here?

An update. I did try using the Sorting and Grouping feature it works but not completely.

1 I need the header to be on each page ok fixed this part already
2 Some pages will show more than one pilot on the page if the amount of data isn't long (say half a page or so)

Other that those two problems Sorting seems to do the job but I need perfection here not almost...