[AGolden]

I'm attempting to create a Mail Merge document based on an Access query of
student data with a high level 'Parent' with one or multiple 'child' records.


I've read up on the NextIF or Next Record IF function but the syntax isn't
working. I'm trying to compare an ID of the current record against the ID of
the next record and when they are the same, print the next 'child' record.
If not, then go to the next page.

Any help would be appreciated.

[Peter Jamieson]

The solution Macropod just mentioned is probably also applicable to your
problem:

------------------
To see how, check out my Word 97-2007 Catalogue/Directory Mailmerge
Tutorial at:
http://www.wopr.com/index.php?showtopic=731107
or
http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip
Do read the tutorial before trying to use the mailmerge document
included with it.
------------------

Peter Jamieson

http://tips.pjmsn.me.uk
Visit Londinium at http://www.ralphwatson.tv

AGolden wrote:
I'm attempting to create a Mail Merge document based on an Access query of
student data with a high level 'Parent' with one or multiple 'child' records.


I've read up on the NextIF or Next Record IF function but the syntax isn't
working. I'm trying to compare an ID of the current record against the ID of
the next record and when they are the same, print the next 'child' record.
If not, then go to the next page.

Any help would be appreciated.

[AGolden]

This is why I usually don't post on message boards. The tutorial wasn't
helpful since it didn't actually have an example of code that I could use and
it gave my PTA laptop a virus.

No such thing as an easy answer.

"Peter Jamieson" wrote:

The solution Macropod just mentioned is probably also applicable to your
problem:

------------------
To see how, check out my Word 97-2007 Catalogue/Directory Mailmerge
Tutorial at:
http://www.wopr.com/index.php?showtopic=731107
or
http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip
Do read the tutorial before trying to use the mailmerge document
included with it.
------------------

Peter Jamieson

http://tips.pjmsn.me.uk
Visit Londinium at http://www.ralphwatson.tv

AGolden wrote:
I'm attempting to create a Mail Merge document based on an Access query of
student data with a high level 'Parent' with one or multiple 'child' records.


I've read up on the NextIF or Next Record IF function but the syntax isn't
working. I'm trying to compare an ID of the current record against the ID of
the next record and when they are the same, print the next 'child' record.
If not, then go to the next page.

Any help would be appreciated.

[Graham Mayor]

If you got a virus, it didn't come from this download - at least not the
copy on my site - and the tutorial includes all the example material you
need - which is why the writer suggested reading the instructions first!

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




AGolden wrote:
This is why I usually don't post on message boards. The tutorial
wasn't helpful since it didn't actually have an example of code that
I could use and it gave my PTA laptop a virus.

No such thing as an easy answer.

"Peter Jamieson" wrote:

The solution Macropod just mentioned is probably also applicable to
your problem:

------------------
To see how, check out my Word 97-2007 Catalogue/Directory Mailmerge
Tutorial at:
http://www.wopr.com/index.php?showtopic=731107
or
http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip
Do read the tutorial before trying to use the mailmerge document
included with it.
------------------

Peter Jamieson

http://tips.pjmsn.me.uk
Visit Londinium at http://www.ralphwatson.tv

AGolden wrote:
I'm attempting to create a Mail Merge document based on an Access
query of student data with a high level 'Parent' with one or
multiple 'child' records.


I've read up on the NextIF or Next Record IF function but the
syntax isn't working. I'm trying to compare an ID of the current
record against the ID of the next record and when they are the
same, print the next 'child' record. If not, then go to the next
page.

Any help would be appreciated.

[macropod[_2_]]

Hi AGolden,

There are no viruses in the tutorial, so it didn't give your "PTA laptop a virus". Kindly get your facts right.

Your claim "The tutorial wasn't helpful since it didn't actually have an example of code that I could use" suggests you either:
a) didn't bother to read the tutorial; or
b) quite unrealistically expected the extensive generic code there to be tailored to your particular situation.

--
Regards
macropod
[Microsoft MVP - Word]


"AGolden" wrote in message ...
This is why I usually don't post on message boards. The tutorial wasn't
helpful since it didn't actually have an example of code that I could use and
it gave my PTA laptop a virus.

No such thing as an easy answer.

"Peter Jamieson" wrote:

The solution Macropod just mentioned is probably also applicable to your
problem:

------------------
To see how, check out my Word 97-2007 Catalogue/Directory Mailmerge
Tutorial at:
http://www.wopr.com/index.php?showtopic=731107
or
http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip
Do read the tutorial before trying to use the mailmerge document
included with it.
------------------

Peter Jamieson

http://tips.pjmsn.me.uk
Visit Londinium at http://www.ralphwatson.tv

AGolden wrote:
I'm attempting to create a Mail Merge document based on an Access query of
student data with a high level 'Parent' with one or multiple 'child' records.


I've read up on the NextIF or Next Record IF function but the syntax isn't
working. I'm trying to compare an ID of the current record against the ID of
the next record and when they are the same, print the next 'child' record.
If not, then go to the next page.

Any help would be appreciated.

[Peter Jamieson]

No such thing as an easy answer.

Not really, no. In this case the "field language" does not contain the
elements necessary to make this kind of thing really easy.

However, I don't think you will find a better source of information and
examples - if you do, perhaps you could post a link here.

Peter Jamieson

http://tips.pjmsn.me.uk
Visit Londinium at http://www.ralphwatson.tv

AGolden wrote:
This is why I usually don't post on message boards. The tutorial wasn't
helpful since it didn't actually have an example of code that I could use and
it gave my PTA laptop a virus.

No such thing as an easy answer.

"Peter Jamieson" wrote:

The solution Macropod just mentioned is probably also applicable to your
problem:

------------------
To see how, check out my Word 97-2007 Catalogue/Directory Mailmerge
Tutorial at:
http://www.wopr.com/index.php?showtopic=731107
or
http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip
Do read the tutorial before trying to use the mailmerge document
included with it.
------------------

Peter Jamieson

http://tips.pjmsn.me.uk
Visit Londinium at http://www.ralphwatson.tv

AGolden wrote:
I'm attempting to create a Mail Merge document based on an Access query of
student data with a high level 'Parent' with one or multiple 'child' records.


I've read up on the NextIF or Next Record IF function but the syntax isn't
working. I'm trying to compare an ID of the current record against the ID of
the next record and when they are the same, print the next 'child' record.
If not, then go to the next page.

Any help would be appreciated.