How to get the average of more fields.
What sign to place between the fields?
For instance: average([age1]&[age2])
The sign & is not correct. Which sign is???

Laura.

"Laura Eekels" <laura.eekels (AT) xx (DOT) yy> wrote

Avg([Field1] + [Field2] + [Field2])

--
Bradley
Software Developer www.hrsystems.com.au
A Christian Response www.pastornet.net.au/response

Thanks for the answer, but I tried that already. and it doesn't work.
Avg([field1]+[field2]) field1=7;field2=8 gives the result 78 and not the
average !?!
Do you have any other suggestions?
Laura

"Bradley" <bradley (AT) REMOVETHIScomcen (DOT) com.au> schreef in bericht
news:jtszb.38208$aT.14986 (AT) news-server (DOT) bigpond.net.au...

I didn't understand what you were asking...

Are you wanting to find the average of all the values in Field1 and Field2
in your table? I think you'd need to somehow collate the values into a
single field perhaps using a few queries to add values to a temp table.
--
Bradley
Software Developer www.hrsystems.com.au
A Christian Response www.pastornet.net.au/response


"Laura Eekels" <laura.eekels (AT) xx (DOT) yy> wrote

"Laura Eekels" <laura.eekels (AT) xx (DOT) yy> wrote

Hello Laura,

I believe what your looking for is to put the following
into your query like this:

Average: ([Field1]+[Field2]+[Field3])/3

You'll notice that the number of fields used determines
the number to divide by. Access doesn't like the Avg()
function to be used within the query. So, the number of
fields you want to get an average for will determine the
number to divided them by.

The end result, I presume, will be displayed as the last
field in your query which will display the result for
each record.

Regards,

Ray