Hi - thought I would give this a try - any help is appreciated.
I have a field separated by semi colons - for example - prod1;prod2;prod3
In a cross tab I'm trying to show which products have a date in them and put an X there. My problem is if the field is like my example - it only shows once and instead of listing each single product as a product - it shows it as one like the example.
I would like to have a column for each product with and X under each.
I hope this is enough information.
Any help is much appreciated.
Thanks.
Bill