Split Reports (1 Viewer)

[davelau]

Is it possible to split the information within a field in a record and print it on two separate reports. Ex. I have a fixed amount of text that I want to print on one page from the field and I want the rest of the text in that field to print on another report.

 

[Chris RR]

There are lots of functions that will split up a text field. Which one you use will depend on how you need to slice-and-dice the field. Look at Mid(), Mid$(), Left(), Left$(), Right() and Right$() in Help, for starters.

If the reports are identical in all other respects, you can base them both on the same query. Have that query bring in the full field, then do the reformatting in the reports.

Otherwise, set up a query for each and do your reformatting there.