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