thread702-1136748
Like the above thread I need to get a std deviataion of a data set on a form.
However, my issue is that my data set could be between 3 and 10 of the circled items.
The remaining 7, 6, 5, 4 fields could be blank.
How do I write this in the macro so it does't throw an error?
The calcs for each of the data sets are;
Av Density (this ones obvious)
Characteristic Voids CV= Avg x + (k*stddev x)
Characteristic Density Ratio CV= Avg x - (k*stddev x)
Have attached a pic to show the common data sets.
Any help on this would be appreciated.
I've had a lot of fun with Access over the years, but this one is getting me.
Like the above thread I need to get a std deviataion of a data set on a form.
However, my issue is that my data set could be between 3 and 10 of the circled items.
The remaining 7, 6, 5, 4 fields could be blank.
How do I write this in the macro so it does't throw an error?
The calcs for each of the data sets are;
Av Density (this ones obvious)
Characteristic Voids CV= Avg x + (k*stddev x)
Characteristic Density Ratio CV= Avg x - (k*stddev x)
Have attached a pic to show the common data sets.
Any help on this would be appreciated.
I've had a lot of fun with Access over the years, but this one is getting me.