OK, so I know how to add fields to a report.
What I am trying to do is add them on the fly.
This report is for a packing slip.
I have 11 fields on my main table, one field for each accessory that comes in with each unit.
These fields are check boxes and 2 of them are text for misc. parts that come in.
On my packing slip, I need to show that I am sending back the accessories that came in with the unit.
So I need to display only the fields that have data in them.
So for instance unit# 21 came in with a cord, cover, and drain. I need to display cord, cover, drain on the packing slip
if unit# 25 came in with nothing, I need to say None on the packing slip.
the only way I can figure out how to do this is to list all fields on the report and show the corresponding check marks, but that isn't acceptable.