HELP! running total

[Barry Collins]

I have a Table with the following fields;

Product, Date of delivery, Amount

I would like to create a Query in which a running total will be calculated on the Amount field for each Date / product.

I can produce a report like this, but would like to create a Query so i can use the results in another Query.
Ps. Using Access 2000
Please HELP ME!

[This message has been edited by Barry Collins (edited 02-06-2002).]

 

[Rich]

Does the table have a unique PK?

 

[Barry Collins]

Sorry what do you mean with PK?

I think you mean (a) field(s) that are key fields. If this is so, my awnser is yes i have 3 other fields in the table, which together are the Unique key for each record.
These fields are cdadmin;cdorder;cdregel

[This message has been edited by Barry Collins (edited 02-06-2002).]

 

[DougS]

Create a Crosstab query using product for your heading and set to do a sum for amount per date.