print next record on same page untill, cell=FALSE then start new page.

[Simon]

I need to print next record on same page untill, cell=FALSE then start new
page.

If the value is TRUE then next row (record) should be added to the same
document.

When the value is FALSE a the record should start on a new document.

I have tried used "Next Record IF" which works where there are multiple
records for the same account, however where there is only one record, it
doesnt print the next record - but the same record again?

Can I work round this?

For example

Bob Smith 12345 TRUE
Bob Jones 12456 TRUE
Sam Smith 13343 FALSE
Joe Peters 3141 FALSE
Mike Smith 213 FALSE
Harry Rivers 31414 TRUE
Bob Rivers 34234 FALSE


This would give 4 pages as follows (note there could be 60+ enteries per
page)

Page 1.

Bob Smith
Bob Jones
Sam Smith

Page 2
Joe Peters

Page 3
Mike Smith

Page 4
Harry Rivers
Bob Rivers

 

[Peter Jamieson]

You are unlikely to be able to do much better than the "multiple items per
condition" approaches described in

http://homepage.swissonline.ch/cindymeister/mergfaq1.htm#DBPic

http://support.microsoft.com/default.aspx?scid=kb;en-us;211303

While it looks as if you ought to be able to, the "field language" isn't
really up to it.

Peter Jamieson