#1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
AGolden AGolden is offline
external usenet poster
 
Posts: 2
Default Next Record IF

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.
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default Next Record IF

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.

  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
AGolden AGolden is offline
external usenet poster
 
Posts: 2
Default Next Record IF

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.


  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default Next Record IF

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.



  #5   Report Post  
Posted to microsoft.public.word.mailmerge.fields
macropod[_2_] macropod[_2_] is offline
external usenet poster
 
Posts: 2,059
Default Next Record IF

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.




  #6   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default Next Record IF

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.

Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Would someone record Alt+X for me? Bear[_2_] Page Layout 3 May 19th 07 12:46 AM
Mailmerge: First Record in stead of Next Record Guus Mailmerge 6 February 6th 07 04:00 PM
Next Record ButterflySis Mailmerge 2 August 24th 06 07:20 PM
Record 21 was an empty record Ima Mailmerge 0 September 15th 05 06:16 PM
Mailmerging graphics only works on first record - how can I get Word to print a new graphic for each record? Graham Mayor Mailmerge 3 May 13th 05 08:00 PM


All times are GMT +1. The time now is 08:22 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"