Concatenate Rows & Records / How to de-normalize records Sometimes you'll need to concatenate records into a single text field. This requirement occurs most often on reports where it is impractical to list many small records down the report. In this example we have patient medical records - in particular we have a table that contains one record for each patient allergy. We have a patient report where we want to list the allergies in one line in a text box - i.e. allergy1; allergy2; allergy3...
DoCmd OpenReport Syntax, Options & Examples You can use the Open Report action to open a report in Design view or Print Preview, or to print the report immediately in screen view (normal view). You can also restrict the records that are printed in the report using a criteria option. The example (below) shows the Docmd.openreport method when used to restrict the selection of records.