Hi everyone,

I'm writting a statistics program and this is my problem: I want to create 3 sets of statistical calculated values: for source='S' field names should end on 'pur' - purchase, for source='M' 'ref' - refinance, and for no matter that source (eithier S or M) 'all'.

Currently I didn't find a better solution, than create RunAll, RunPur and RunRef functions, which are almost identical except I use different appropriate field names and in two first cases where condition. Unfortunately, this makes my life very hard, if I want to change code. I have to make the same changes in all three functions.

Do you have better ideas for me? I'd like to avoid macros if possible.

Thanks in advance.