Jan 14 2004, 10:27 AM
I have monthly volume data for several different insurance companies. I would like to list the monthly data in one column and add another column for the corresponding month. In other words have 12 rows of data for each insurance company.
After re-reading this I descided to attach my spreadsheet to make it more self explanatory.
Jan 14 2004, 10:50 AM
Actually having twelve rows for each company is the RIGHT way to STORE the data. Then as more rows get added it will not require more FIELDS. However, what you are looking at here is called a cross-tab query. You can always get this result by creating a cross-tab query or Pivot table report in Excel as long as you have a date with every row. Group By Company and Group By Month and Sum or Avg in the Value. Try it out!!!