Page breaks

[pickle76]

Help! I have a report (based on query) where I'd like to place a page break everytime the first column, "Brand", changes. When I use the sort and grouping function I can only sort ascending/descending. The problem here is that there is a particular order that these brands need to be on the report...and it's not alphabetical. There's a field in the query that states what order they should be in.
Any suggestions?

thx, Jen

 

[RichMorrison]

You wrote
<<
There's a field in the query that states what order they should be in.
>>

Then Sort/Group on the "other" field.

RichM

 

[Rich]

Add the query field to the report and hide it

 

[pickle76]

Works, thanks.
I wish I could say it was friday and i wasn't thinking straight...'cause that seems to easy.