How do I run a query where the expenses of each distrubutor during a specific period are sumed?

[erikl1]

How do I run a query where the expenses of each distrubutor during a specific period are sumed? The query should contain only one line for each distributor.

[burrina]

Group by Distributor and then sum in a crosstab query and I assume you have a date field where you can sort by start and end date.
You did not provide any real information to direct you!

HTH

[erikl1]

Thank you Burrina.

I still have problems. I did not describe my problem in sufficient detail. I try again:

I want to extract info from a table that keeps track of expenses. The fields of interest are (a) Name of Seller, (b) Date of sale, (c) Bill (amount spent). The dates distribute over long time, and sales are repetitive. I want to make a table showing the expenses over a limited period (specified by a start and a stop date). The query should generate a list containing (a) the Names of Sellers, and (b) the amount of money spent on each seller (sum over the period).

[June7]

As burrina suggested, do an aggregate (GROUP BY) Totals query. Access Help has guidelines on using the query builder.

Or build a report and use Grouping & Sorting features with aggregate calcs in footer section. Again, Access Help has guidelines.

This is really basic Access functionality. Any introductory tutorial book should have description of these techniques.