Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / January 2007

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Simon - 12 Jan 2007 18:24 GMT
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 - 16 Jan 2007 15:26 GMT
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

>I need to print next record on same page untill, cell=FALSE then start new
>page.
[quoted text clipped - 38 lines]
> Harry Rivers
> Bob Rivers
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.