I have this Access query that has the following fields:
Pair: These are various forex pairs like AUD/CAD, AUD/CHF, etc, etc..totally 54 pairs.
Value: This is a field that contains values of the forex on a 0-100 scale. This is on an ascending scale, starting from 1 and going till 100; for each pair.
Frequency: How many times the value has occurred.
Now my question is how do I Cumulate Frequency ?
My initial query has the format: Pair-Value-Frequency
My output should be: Pair-Value-Frequency-Cumulative Frequency
I need the help of experts.
Pair: These are various forex pairs like AUD/CAD, AUD/CHF, etc, etc..totally 54 pairs.
Value: This is a field that contains values of the forex on a 0-100 scale. This is on an ascending scale, starting from 1 and going till 100; for each pair.
Frequency: How many times the value has occurred.
Now my question is how do I Cumulate Frequency ?
My initial query has the format: Pair-Value-Frequency
My output should be: Pair-Value-Frequency-Cumulative Frequency
I need the help of experts.