The date is entered once on the RPT (i.e the header), then a table of "items" is listed on the RPT. This RPT is then used to generated individual labels - which as well as using row data from the table also used the sole date entry from the header as well as other singular data (such as incident number and project name). Also, I will not be running this file/rpt myself (I am just attempting to automate a very slow, manual, duplicated data entry process) so would like to keep as low maintenance as possible, (in the event of anything going wrong) and would thus like to avoid Macros..
Apologies -- the data is not needed IN COLUMNS FORMAT .. I.E. entered multiple times.. it is static and is just entered once, in header not per row
|