Solved Trying to figure out how to start new column in a report after a given amount of records

[eibyer_apc]

this is report of sample names.

Thank you for this @arnelgp. I tried it and it worked like how I was expecting it to. Sorry for the delayed reply, had to watch some youtube videos on access vba to kind of get a feel for what the code was doing.

I have a question though, what's the Const FP_LINES = 30 and Const NP_LINES = 32 variables for?

 

[arnelgp]

FP_LINES = number of lines in First Page
NP_LINES = number of lines on Next Page.