Creating a RUNNING PRODUCT query

[VBAguy22]

Hi all,
I have a table, myTable, sorted properly by PROVINCE, POSTALCODE and AREACODE. The last field in the table is FACTOR field. I need to create a query that will create a running product based on area code. Note that the count has to restart each time we have a new area code.

Any help? Thanks!

 

[VBAguy22]

To Clearify: The running product has to be on the FACTOR field.

 

[PHV]

Do a keyword search in this forum for rank or ranking

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886