Tabular data with mixed dates - how to handle? "Fred Marshall" <fmarshallx[ at ]remove_the_x.acm.org> 26.07.2006 17:11:49 I need a "nudge" in the right direction with this. I don't often use Access but do need to use it here. I have an Excel spreadsheet that lists customers, consumption, etc. and there is an entry for some months for each customer. Some are every month, others are every other month. I have separate rate tables that I can link so that I can generate bills from usage and the applicable rate for each customer. Doing this, I'm able to generate charges for each customer for one month. But, there are multiple months involved in the original data. I want to integrate the data into single rows for each customer and multiples columns (by month) so I can calculate the charges for each customer for each month in one row of a query. (Then I'll add up all the months to get an annual total column). I haven't quite figured out how to get the data to go from many rows into fewer rows and more columns. I have been able to extract all the data for each month into a separate query but that's not quite getting me there. Suggestions would be appreciated. Fred