I have a query that contains data like this:

Course Units
Brickwork 8
Joinery 12
Music 25
Catering 5
Hair 12 etc etc

In the report I want each course on a different page and I want it to show the same amount of blank rows as the units column.

So Brickwork will have 8 rows (lines?) and then joinery on a new page will have 12 rows etc

I hope you can help me please!

Thanks for reading

In the report I want each course on a different page ...You can GROUP BY Course or Course ID (preferable) on the report.

... and I want it to show the same amount of blank rows as the units column.The methods you would need to achieve this are:
Me.MoveLayout
Me.NextRecord
Me.PrintSectionYou would need to manipulate them to get the fixed number of blank lines. They can be set using boolean values, True or False. So if you want to set MoveLayout you do this:
Me.MoveLayout = TrueHave a look in the help files for an explanation of these methods.

Thanks for the very quick reply!

I should have said but I don't know any VB so how do I use the methods that you have listed?

Thanks again
Lisa

If you want a more detailed explanation, have a look in the help files. Here's what I found from just Googling:

http://www.everythingaccess.com/tutorials.asp?ID=Reports%3A-Create-a-blank-line-every-fifth-record

http://www.msaccesstips.com/2009/07/detail-and-summary-from-same-report/

Well, I thought since I had a few moments I should create an example to help you, so here it is. See attached.

(I converted it to 2000 in case you didn't have 2007)