customizing merge documents

[Sandy]

I am trying to create a merge document using Microsoft Access. My
document will have several sections each requiring different filtered
data from the same database. I can filter no problem using <Next
Record If> but I need to enter text between each set of filtered
records and am unable to do so. Can anyone suggest what I may be
doing wrong.

e.g.
Bachelor of Arts (heading)

«Next Record If»«cal_subj» «cal_num» (If = not equal to SCIE)

Bachelor of Science (heading)

«Next Record If»«cal_subj» «cal_num» (If = not equal to ARTS)

This returns the heading before each record in the set.

Thanks!

 

[Doug Robbins]

Sounds to me like you should be using a report in Access.

See the "Multiple items per condition" item under the "Special merges"
section of fellow MVP CIndy Meister's website at

http://homepage.swissonline.ch/cindymeister/MergFram.htm


--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP