I've seen some postings on here for creating procedures and modules to calculate the median. In my case I want to see the median of all rates in my table. I am using a fiedl that is data derived from an Expression using an IIf statement. This expression "looks" at other Rate fields in a table and returns the most recent rate. The problem is that the code for the procedure is for a double integer. I am not a programmer and need help figuring this one out.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Procedure for Median for a field that is an expression
- Thread starter istuart
- Start date
I'm puzzled. There is no such thing as a "double integer" in Microsoft Access. There are Long integers and Double Precision Floating Point, however.
I just finished coding up a generic function to derive the median of any value. AMOF, since a Double is a 64 bit floating point number, it will hold just about anything.
That the column in question is a formula is irrelevant. Your median function takes the values from the column as input, just as the intrinsic functions do.
I just finished coding up a generic function to derive the median of any value. AMOF, since a Double is a 64 bit floating point number, it will hold just about anything.
That the column in question is a formula is irrelevant. Your median function takes the values from the column as input, just as the intrinsic functions do.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
