|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
January 16th, 2006, 01:03 PM
posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
"Next Record If", Mail Merge Issues
I am using an Access database source and using Access 2003 and Word
2003. I'm having a problem with the "Next Record If" feature. I am using this format when I am merging my data: RCA#: _ «RCA»_____________________ (Format: RCAyymmdd-abcnn, where abc=tech initials, nn=number counter) ROOT CAUSE ANALYSIS Date:_«Date» (INV/Pallet#:_«INVPallet» ) Tech Name:_«Tech_Name» (Batch#:_«Batch» ) Equipment/Device:_«Equipment_Type» · Model Number:_«Model_Number» · Serial Number: _«Serial_Number» · (Equip #:_«Equipment_Number» ) User: _«User» Phone: _«User_Phone» · Building:_«Building» · Room/Cube Number:_«RoomCube_Number» PROBLEM TYPE: «Problem_Type» Troubleshooting No. Step «Problem_Description» «Steps_to_Complete» «Next Record If»«Problem_Description» «Steps_to_Complete» «Next Record If»«Problem_Description» «Steps_to_Complete» «Next Record If»«Problem_Description» «Steps_to_Complete» «Next Record If»«Problem_Description» «Steps_to_Complete» «Next Record If»«Problem_Description» «Steps_to_Complete» «Next Record If»«Problem_Description» «Steps_to_Complete» «Next Record If»«Problem_Description» «Steps_to_Complete» «Next Record If»«Problem_Description» «Steps_to_Complete» «Next Record If»«Problem_Description» «Steps_to_Complete» «Next Record If»«Problem_Description» «Steps_to_Complete» RESOLUTION: Unit was: _«Resolution_Fixed__Replaced»_____________________ · Number:_«Resolution» Still pending? _«Resolution_Pending»____________ «Resolution_Pending_Detail» The "Next Record If" is not working correctly. I have a variable number of problem descriptions and steps to complete. It successfully puts those two but when I get down to Resolution and try to merge them I think it tries to pull from a record that is blank. My "Next Record If" condition is that it will go to the next record if the Problem Description is not blank. It will work when I have resolution before I do all the next record if but not if it's after which is where it needs to be. I was thinking maybe there might be a way to go to the first record to get the resolution information or somehow to do multiple merges under one document but I'm not sure about how to go about this. Thank you in advance. Jason Baxter 
|
|
#3
January 16th, 2006, 04:18 PM
posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
"Next Record If", Mail Merge Issues
Yes it does show this. It won't copy and paste onto here but it shows
{ NEXTIF { MERGEFIELD Problem_Description } "" } In this Word document I have 11 rows that can be merged. I need to find out how to make an append query that will append a variable number of blank rows up to 11 where it needs to be the information from the first row. What I was looking at is to make a query that counts the number of rows and use that number to create the other query to append my blank rows and another one to append the first row's information. I wish there was an easier way to do this but it looks like there no way to get around this. I hope you can help me. Thank you.
|
|
#4
January 16th, 2006, 06:45 PM
posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
"Next Record If", Mail Merge Issues
Given that your data is in an Access database, you should be using an Access
Report, not mailmerge. Word does NOT have the ability to merge multiple items for a single condition. See the "Group Multiple items for a single condition" item on fellow MVP Cindy Meister's website at http://homepage.swissonline.ch/cindy...faq1.htm#DBPic Or take a look at the following Knowledge Base Articles http://support.microsoft.com/default...b;en-us;302665 http://support.microsoft.com/default...b;en-us;294686 But if I were you, I would use an Access Report! -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP wrote in message oups.com... Yes it does show this. It won't copy and paste onto here but it shows { NEXTIF { MERGEFIELD Problem_Description } "" } In this Word document I have 11 rows that can be merged. I need to find out how to make an append query that will append a variable number of blank rows up to 11 where it needs to be the information from the first row. What I was looking at is to make a query that counts the number of rows and use that number to create the other query to append my blank rows and another one to append the first row's information. I wish there was an easier way to do this but it looks like there no way to get around this. I hope you can help me. Thank you.
|
|
#5
January 20th, 2006, 02:45 PM
posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
"Next Record If", Mail Merge Issues
How would you make a report that has multiple conditions on one page.
I got it to put it on multiple pages but that's not what I want. Thank you
|
|
#6
January 20th, 2006, 08:55 PM
posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
"Next Record If", Mail Merge Issues
You use grouping in the report design with the single item plus the text
associated with it in the group header, and the multiple items in the detail section of the report and any closing text in connection with the single in the group footer. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP wrote in message oups.com... How would you make a report that has multiple conditions on one page. I got it to put it on multiple pages but that's not what I want. Thank you
|
|
#7
February 8th, 2006, 05:22 PM
posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
"Next Record If", Mail Merge Issues
Could someone go into more detail on how to put for example if you had
this data RCA#: _ «RCA»_____________________ (Format: RCAyymmdd-abcnn, where abc=tech initials, nn=number counter) ROOT CAUSE ANALYSIS Date:_«Date» (INV/Pallet#:_«INVPallet» ) Tech Name:_«Tech_Name» (Batch#:_«Batch» ) Equipment/Device:_«Equipment_Type» · Model Number:_«Model_Number» · Serial Number: _«Serial_Number» · (Equip #:_«Equipment_Number» ) User: _«User» Phone: _«User_Phone» · Building:_«Building» · Room/Cube Number:_«RoomCube_Number» PROBLEM TYPE: «Problem_Type» Troubleshooting No. Step «Problem_Description» «Steps_to_Complete» «Problem_Description» «Steps_to_Complete» «Problem_Description» «Steps_to_Complete» «Problem_Description» «Steps_to_Complete» «Problem_Description» «Steps_to_Complete» «Problem_Description» «Steps_to_Complete» RESOLUTION: Unit was: _«Resolution_Fixed__Replaced»_____________________ · Number:_«Resolution» Still pending? _«Resolution_Pending»____________ «Resolution_Pending_Detail» There is the Equipment table and Problem table. The Problem table has: Problem Description and Resolution along with the foreign key from Equipment I'm not quite understanding how to use grouping in the design view of reports and how to connect the multiple fields together without getting multiple pages if I have more than one problem. Thank you in advance
|
|
#8
February 8th, 2006, 06:30 PM
posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
"Next Record If", Mail Merge Issues
I figured it out.
Thank you for all your previous help
|
|
#9
February 8th, 2006, 07:11 PM
posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
"Next Record If", Mail Merge Issues
Never mind, I figured it out
Thank you for all your help in the past.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| word+excel mail merge omits 1st numeric record | JDavidson | Mailmerge | 5 | January 12th, 2006 11:15 AM |
| Access and appending records and Excel into Word Mail Merge | rmoritzky | General Discussion | 2 | October 20th, 2005 04:05 PM |
| Mail Merge Issues from Access to Word | John O via OfficeKB.com | Mailmerge | 5 | August 21st, 2005 06:23 AM |
| Access Mail Merge to Word.doc files ? | RNUSZ@OKDPS | Setting Up & Running Reports | 1 | May 18th, 2005 06:31 PM |
| How to choose your own record deliminators in mail merge? | GMed | Mailmerge | 1 | January 22nd, 2005 12:44 AM |
Linear Mode
