Cheryl,

Put each of the fields on the report in the place where you want it with "Remove line if blank" checked and "Print when" statements tied to something in the data. For example, Print when State = "MA". The fields will probably overlap. You can also use "Print when" for headers and titles and lines.



>thanks for the corrections
>
>I have one report that needs to change in 15 different areas depending on the state. Right now I say in this area print memo 1 this area print memo#2 etc. when changing to a more normalized database design I have a detail table with multiple records containing each memo field. How can you tell the report where to print the correct one? I hope this makes sense. Thanks again for your help