how to use AVERAGE function across

[mugziegumz via AccessMonster.com]

I have 3 columns in my table: Attitude, Communication, Performance. I want
my last column to total across (NOT DOWN) the 3 ratings. Is this possible?
I'm brand new with access!
Shannon

 

[Douglas J. Steele]

You can't do it in a table, but you can create a query that does it for you.

Create a new query and select your table. Grab all of the fields, and drag
them into the grid. In an empty cell on the Field rows, type the following:

Average: (Nz([Attitude], 0) + Nz([Communication], 0) + Nz([Performance], 0))
/ 3

Use the query wherever you would otherwise have used the table.

 

[mugziegumz via AccessMonster.com]

Being new with Access I'm not sure what "In an empty cell on the Field rows"
means. Where is this empty cell on field rows? Is this in a query? Where?
Brand new thanks!
shannon

You can't do it in a table, but you can create a query that does it for you.

Create a new query and select your table. Grab all of the fields, and drag
them into the grid. In an empty cell on the Field rows, type the following:

Average: (Nz([Attitude], 0) + Nz([Communication], 0) + Nz([Performance], 0))
/ 3

Use the query wherever you would otherwise have used the table.

I have 3 columns in my table: Attitude, Communication, Performance. I want
my last column to total across (NOT DOWN) the 3 ratings. Is this possible?
I'm brand new with access!
Shannon

 

[Douglas J. Steele]

If you follow the first two steps of my instructions ("Create a new query
and select your table. Grab all of the fields, and drag them into the
grid."), you're going to be in the query builder. The grid to which you
dragged the fields has row labels on the left-hand side. The top row should
be labelled "Fields". Find an empty cell on that row, and type what I
indicated into it.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

Being new with Access I'm not sure what "In an empty cell on the Field
rows"
means. Where is this empty cell on field rows? Is this in a query? Where?
Brand new thanks!
shannon

You can't do it in a table, but you can create a query that does it for
you.

Create a new query and select your table. Grab all of the fields, and drag
them into the grid. In an empty cell on the Field rows, type the
following:

Average: (Nz([Attitude], 0) + Nz([Communication], 0) + Nz([Performance],
0))
/ 3

Use the query wherever you would otherwise have used the table.

I have 3 columns in my table: Attitude, Communication, Performance. I
want
my last column to total across (NOT DOWN) the 3 ratings. Is this
possible?
I'm brand new with access!
Shannon

 

[mugziegumz via AccessMonster.com]

Ok, I did as stated. However, when I run the query I get a total of 1936.
66666666667 for my average of the 3 listed below....what am I doing wrong?

Attitude: 5
Communication: 8
Performance: 10

If you follow the first two steps of my instructions ("Create a new query
and select your table. Grab all of the fields, and drag them into the
grid."), you're going to be in the query builder. The grid to which you
dragged the fields has row labels on the left-hand side. The top row should
be labelled "Fields". Find an empty cell on that row, and type what I
indicated into it.

Being new with Access I'm not sure what "In an empty cell on the Field
rows"

[quoted text clipped - 21 lines]

 

[Douglas J. Steele]

While your query is open in Design view, change the view to SQL View.

Copy the SQL statement that was generated into your reply.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Ok, I did as stated. However, when I run the query I get a total of 1936.
66666666667 for my average of the 3 listed below....what am I doing wrong?

Attitude: 5
Communication: 8
Performance: 10

If you follow the first two steps of my instructions ("Create a new query
and select your table. Grab all of the fields, and drag them into the
grid."), you're going to be in the query builder. The grid to which you
dragged the fields has row labels on the left-hand side. The top row
should
be labelled "Fields". Find an empty cell on that row, and type what I
indicated into it.

Being new with Access I'm not sure what "In an empty cell on the Field
rows"

[quoted text clipped - 21 lines]

I'm brand new with access!
Shannon