Calculate Average in a Query

[SteveL]

I have a query which returns 5 values in 5 separate
fields. (V1, V2, V3, V4, and V5). In the next field I
want to average these 5 values. How do I write the
formula to do this?

Then to make it even more complicated, if the value in
any of the fields is "0", I don't want it ncluded in the
calculation.

Finally, what I really want is the MEDIAN calculated.

Can anyone help?

--Steve

 

[SteveL]

Peter,

Thanks, and yes, please provide the link.

--Steve

 

[SteveL]

Peter,

Thank you very much. I really appreciate the help.

--Steve

 

[SteveL]

Peter,

I just realized that the solution you've presented will
calculate median on the same field for any number of
records, or so I believe. But what I need to to do is
calculate media on 5 fields... Val1, Val2, Val3, Val4,
Val5 within one record. Am I missing something?

--Steve