Hi,
I have an access query that has 2 columns: CAUSE and count(records) having the respective CAUSE value. I want to add another column that will give me all the ACCOUNT NUMBERS same as the number mentioned in the COUNT column. Also i want all these ACCOUNT NUMBERS to appear in comma separated format on the crystal report.
Any suggestion as to how we can convert the recordset to a comma separated string.
Thanks.