I hope you can help, I have two columns in a table that represent the a monthly plan and a monthly execution, they used to be 24 columns but I have reduced them to two by seperating the months with a comma. this is now required to go back into excel to be displayed as single months for each value ie Plan months would be 3,4,5 this would now give you Month3 =1 month4 =1 month5=1 in excel with all other months having a zero value unless they were Execution months these would also have 1's in them.
I'm stumped. Does any one have any ideas? I'm using Access 2000 sp3

Aaaaagh! Two design problems in one!

Your first approach with 24 colums was wrong, but consolidating these into two columns has made it even worse.

How much data do you have? A redesign would be preferable unless you have huge amounts of data.

Thanks for your response. I was actually lumbered with this, trying to fix a bad mess started by someone else!!
In the end the whole table is far too big to redesign so it will stay as it is and the values will be exported into excel and some jiggery pokery will take place in excel to produce the results needed.
Cheers!!