Calculate the Average

[Jerseynjphillypa]

I have this formula I run in Excel once my database is finish running in Access



=AVERAGEIF(Item,B2,Total)

I was wondering If I can do the same thing in Access

I have a filed (Header) called Item and I just select the range in the Name Manager section so i don't have to select every cell

Then B2 is where I get the name of the cell in that row. I also attached an example

[John_G]

Hi -

Well, yes and no - but mostly no. Can you do it the same way as Excel does? No. When Access displays data, even in datasheet view, it does not know anything about data other than the row which the cursor is on. There is no concept of a "range", of referring to a "cell" in another row. The same is true for recordsets in VBA - you can refer only to the set member you are currently "on".

You would have to write a VBA routine to do what you want to do.

John