View Single Post
  #7   Report Post  
Posted to microsoft.public.word.mailmerge.fields
 
Posts: n/a
Default "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