Cumulative Percent

[JD]

My intent is to add a field to my table that contains the cumulative
percentage of the CumFreq field (cumulative frequency). Any help would be
greatly appreciated. My source table ‘AllinOne’ looks like this:

Speed,Frequency_Vehicles,CumFreq,WeekNum
10,1,1,31
13,1,2,31
14,1,3,31
17,3,6,31
20,1,7,31
Etc, etc.

Thanks

 

[Bob Barrows]

My intent is to add a field to my table that contains the cumulative
percentage of the CumFreq field (cumulative frequency). Any help
would be greatly appreciated. My source table 'AllinOne' looks like
this:

Speed,Frequency_Vehicles,CumFreq,WeekNum
10,1,1,31
13,1,2,31
14,1,3,31
17,3,6,31
20,1,7,31
Etc, etc.

Thanks

Please show us what the results need to look like.

 

[John W. Vinson]

My intent is to add a field to my table that contains the cumulative
percentage of the CumFreq field (cumulative frequency). Any help would be
greatly appreciated. My source table ‘AllinOne’ looks like this:

Speed,Frequency_Vehicles,CumFreq,WeekNum
10,1,1,31
13,1,2,31
14,1,3,31
17,3,6,31
20,1,7,31
Etc, etc.

Thanks

YOu really, really do NOT want to add this calculated field to your table.

Storing derived data such as this in your table accomplishes
three things: it wastes disk space; it wastes time (almost
any calculation will be MUCH faster than a disk fetch); and
most importantly, it risks data corruption. If one of the
underlying fields is subsequently edited, you will have data
in your table WHICH IS WRONG, and no automatic way to detect
that fact.

Just redo the calculation whenever you need it, either as a
calculated field in a Query or in the control source of a Form or a Report
textbox.

 

[John Spencer]

How do you intend to calculate the Cumulative Percentage?

CumFreq divided by SOME NUMBER. What is that number? How is it calculated?

As advised elsewhere it is not a good idea to store this in the table in most
cases as it will be subject to being wrong if you modify any record.

Also what defines the order of the records that defines the accumulation?
Looking at your sample data I would guess that the Speed field (and perhaps)
the WeekNum field) may define the order.

Also I note that CumFreq is another value that should not normally be saved in
the table since it is again subject to being wrong if you modify any record.

For instance if you find that the first record should have been entered as
10,2,2,31
and fix that then all the subsequent records would have to be edited.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County