I posted yesterday about some unnormalized data that I inherited. Thanks to Len & Uncle who responded with solutions. We are STILL 
working to clean up that mess & get some usable data. However, we are thinking ahead to the future and how we can do this better next year. My question now is, can anyone recommend a good program to use to create a web-based survey that will give the results in a normalized access data format that can be easily manipulated, calculated, etc. in an Access report without a lot of clean up. This year's survey was created in FrontPage 2003, but the data came back with each possible answer in a separate field, so that each question was spread among several fields (2-7 fields per question).
Thanks for any suggestions you may have.
working to clean up that mess & get some usable data. However, we are thinking ahead to the future and how we can do this better next year. My question now is, can anyone recommend a good program to use to create a web-based survey that will give the results in a normalized access data format that can be easily manipulated, calculated, etc. in an Access report without a lot of clean up. This year's survey was created in FrontPage 2003, but the data came back with each possible answer in a separate field, so that each question was spread among several fields (2-7 fields per question).Thanks for any suggestions you may have.
