Can you do this: use the actual field name. For example, do you want:
"drawing no, drawing no, drawing no...
or
"part number, part number, part number...
when you say number 1 number 2 etc?
Also, what is the "restraint" field? I see "divan," "drawing no," and "part number," but no restraint field.
What I think you should do is to create a table with your two columns, like this:
tblReport
mConcatenate - memo
tRestraint - text
Then create a delete query to remove all items from the table before you run each report.
Then create the code to concatenate the fields in the memo column, and add the restraint column.
Then run the report.
You can take parameters and then pass them to the SQL string that opens the recordset to build the data.
Will that work?
mmcdonal
Look it up at:
http://wrox.books24x7.com