D
Doug
I have data that are grouped by year and quarter. I would
like to calculate a median value of a variable for each
year and quarter. I attempted to use the code on the
support website, but the openrecordset statement suggested
generates a "wrong number of arguments - expected 4" error
when executed.
So..I need help with two issues:
1. Is the median function suggested on the support site
the correct one to use for my purposes? If not, where can
I find the correct one or make modifications to produce a
median for each year and quarter in my dataseet?
2. Why doesn't it work?
like to calculate a median value of a variable for each
year and quarter. I attempted to use the code on the
support website, but the openrecordset statement suggested
generates a "wrong number of arguments - expected 4" error
when executed.
So..I need help with two issues:
1. Is the median function suggested on the support site
the correct one to use for my purposes? If not, where can
I find the correct one or make modifications to produce a
median for each year and quarter in my dataseet?
2. Why doesn't it work?