Average of a number of fields (1 Viewer)

[JamesMcS]

Thanks APR - VBA solved this one for me last week but your code looks interesting!

 

[scubadiver007]

Hi all - I'm almost certainly being an idiot, but it's been a long week....

I've got 12 fields that I need to take an average from. How do I do this in one field in a query? I get the feeling I'm going to be slapping my forehead and saying "D'oh" in a loud voice in the middle of the office.... I tried (field1+field2....)/12 but there are some zeroes in there which, if possible, I'd like to avoid.

Ta in advance!

To me, that sounds like a simple design issue!

 

[JamesMcS]

Forgotten I'd started this thread....

Not a design issue at all - I needed average sales, where there were sales, across a number of countries, represented by a number of different fields in the table.

VBA's solution worked perfectly.

 

[apr pillai]

Check this out: http://msaccesstips.com/2008/11/sum-min-max-avg-paramarray/

 

[JamesMcS]

Thanks, but this thread was solved months ago

 

[apr pillai]

Sorry, I didn't see the earlier entry of mine.