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!
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

Signature
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
>I am trying to create a merge document using Microsoft Access. My
> document will have several sections each requiring different filtered
[quoted text clipped - 15 lines]
>
> Thanks!