Recent content by freud52
-
F
Need excel formula translated to access
I have a formula from an excel trendline that will calculate a percentile score. I would like to be able to use it in access, perhaps in a query. Can anyone help me?? -
F
Update table field based on another field.
do you mean make another table, and say, call it GadTable, and have 2 columns, one for GaDRaw and one for GaDPer? OK, but how do i pull out the correct GaDPer value, based upon the value of GaDRaw - then populate the field in the first table? can you show me an example of what you are talking about? -
F
Update table field based on another field.
yes, the "GaDRaw" field, or raw score, is related to the "GaDPer" field, or percentile score. the formula to calculate the percentile from the raw score escapes me. i'm using a graph i have that has the raw scores and %tile scores for reference. and yes, i know it's bad form to work off of a... -
F
Update table field based on another field.
Ok. I've got a table named SIPATable and some of the fields contain summed values. Let's say for instance I have a field named "GaDRaw", which represents a raw score. now...I need to update a field called "GaDPer", based upon the value in "GaDRaw". So...If "GaDRaw" <=16, then I would want...