Average IF?

[turtle]

Is there an average if function in Access?
I need to average a field if a corresponding field matches a certian
criteria.

Field 1 field2
..5 .6
..2 .4
..6 .3
..1 .19

If field 1 is less than .25 then i want a average of field 2 for those
records.

TIA,
KO

[lyle fairfield]

turtle <ko****@vistacontrols.comwrote in news:d0c9dc8c-a0da-4f1e-9ca4-
b2**********@c65g2000hsa.googlegroups.com:

Is there an average if function in Access?
I need to average a field if a corresponding field matches a certian
criteria.

Field 1 field2
.5 .6
.2 .4
.6 .3
.1 .19

If field 1 is less than .25 then i want a average of field 2 for those
records.

TIA,
KO

Perhaps, I am misunderstanding you. I believe this will calculate what I
think you want.

SELECT AVG(Field2) FROM Table1 WHERE Field1 < 0.25

[frogsteaks]

On Mar 25, 4:08*pm, lyle fairfield <[e-mail]:

turtle <[e-mail] in news:d0c9dc8c-a0da-4f1e-9ca4-
[e-mail]:

Is there an average if function in Access?
I need to average a field if a corresponding field matches a certian
criteria.

Field 1 * field2
.5 * * * * * *.6
.2 * * * * * *.4
.6 * * * * * *.3
.1 * * * * * *.19

If field 1 is less than .25 then i want a average of field 2 for those
records.

TIA,
KO

Perhaps, I am misunderstanding you. I believe this will calculate what I
think you want.

SELECT AVG(Field2) FROM Table1 WHERE Field1 < 0.25

Damn now I feel stupid.

[Guillermo_Lopez]

On Mar 26, 2:23*pm, [e-mail] wrote:

On Mar 25, 4:08*pm, lyle fairfield <[e-mail]:

turtle <[e-mail] in news:d0c9dc8c-a0da-4f1e-9ca4-
[e-mail]:

Is there an average if function in Access?
I need to average a field if a corresponding field matches a certian
criteria.

Field 1 * field2
.5 * * * * * *.6
.2 * * * * * *.4
.6 * * * * * *.3
.1 * * * * * *.19

If field 1 is less than .25 then i want a average of field 2 for those
records.

TIA,
KO

Perhaps, I am misunderstanding you. I believe this will calculate what I
think you want.

SELECT AVG(Field2) FROM Table1 WHERE Field1 < 0.25

Damn now I feel stupid.- Hide quoted text -

- Show quoted text -

SELECT AVG(Field2) FROM Table1 WHERE Field1 < 0.25

This would work fine, if all you wanted to obtain was that average.
But if there are other calculations in the query you'd need a select
for each calculation.

- GL