Have you considered opening Excel and creating a pivot table based on your
Access data?
--
Duane Hookom
Microsoft Access MVP
"mrmag2000" wrote:
[Quoted Text] > Hello, I am in need of some help on how to create a report that gathers the
> information needed below.
>
>
> I currently have an Access file that has over 100,000 records with about 30
> different columns of information.
>
> One of the columns lists a "class" of customer. One, Two and Three (class).
>
> Another column has a total amount they have paid over the lifetime of their
> membership (all years totaled).
>
> And another column has the year in which they became a customer.
>
> Basically with these columns of information, I would like to get a report (or
> anything that works the best) the first sorts the customers by Class. Then I
> would like it to sort the customers by they year they became a customer. And
> next I would like to get a grand total of the dollar amount spent by the
> customers (for all customers in a given inception year). For example: For
> customers that became a member in 1980, I would like to have the total amount
> of money they spent over their entire life. Then another subtotal for
> customers created in 1981...etc. Finally, I would like to have a count of
> each year that's under each class. So since I'm just interested in class
> "One", I would like to get the count of all 1980 customers that are in class
> One. Then all 1981 customers that are in class One.
>
> I do not want to see the detail of each customer. My main goal is to be
> able to put this into an excel file to run a chart
>
>
> I would like it to look something like this....
>
> Class One
> Year Amount Number of Customers
> 1980 $550.00 85
> 1981 $751.00 36
> 1982 $968.00 91
>
> Class Two
>
|