Tabular data with mixed dates - how to handle?

F

Fred Marshall

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top