Davg Question!

[JOM]

I want to use DAVg but am not sure how to use it. I have a 2 fields in my
table FieldA and FieldB so what I would want is
get the average of (FieldA/FieldB)/100 How will this work?

 

[Dirk Goldgar]

I want to use DAVg but am not sure how to use it. I have a 2 fields
in my table FieldA and FieldB so what I would want is
get the average of (FieldA/FieldB)/100 How will this work?

So you want the average of that expression? You should be able to write

DAvg("(FieldA/FieldB)/100", "YourTableName")

 

[Douglas J. Steele]

Note, though, that you'll have a problem if FieldB is 0.

 

[Dirk Goldgar]

Note, though, that you'll have a problem if FieldB is 0.

True indeed.