Hi AccessForum,
I have a report with a field called D_Lots_used.
the text stored in this field has the following format: DAA0001. Sometimes the field includes up to 5 of these DAA numbers, something like this: DAA0001, DAA0002, DAA0005, etc.
in the case of 5 of these D numbers (actually they are lot numbers) the report wants to display them as one long stright, with no space after the commas.
Is there a way to easily format this to where it displays something like:
DAA0001, DAA0002
DAA0003, DAA0005 ?
any hints, advice or nudges in the right direction would be very appreciated!
thanks,
J