Access Calcuulate avg number of days

  • Thread starter Thread starter Guillermo
  • Start date Start date
G

Guillermo

An examply to "Subject: Calculate the average number of days (Access data
base)"
posted this morning.

Agreement Number Nodays
99363154553 12
94474282 11
9311802 10
98512292721365 7
48482632 6

This my table. I need to sum the number of days (46) and calculate the
average.
46 divided by the number of rows (5) -> 9.2. Easy mental arithmatic, but how
do I do it in ACCESS?
 
Any reason for not just using

=DAvg("[NoDays]","MyTable")

The Help file says "Records containing Null values aren't included in the
calculation of the average"

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Klatuu said:
=DSum("[NoDays]","MyTable") / DCount("*", "MyTable", "NoDays Is Not Null")
--
Dave Hargis, Microsoft Access MVP


Guillermo said:
An examply to "Subject: Calculate the average number of days (Access data
base)"
posted this morning.

Agreement Number Nodays
99363154553 12
94474282 11
9311802 10
98512292721365 7
48482632 6

This my table. I need to sum the number of days (46) and calculate the
average.
46 divided by the number of rows (5) -> 9.2. Easy mental arithmatic, but
how
do I do it in ACCESS?
Click to expand...
Click to expand...
 
Yes, I have a very good reason.

I didn't think about it. <g>
--
Dave Hargis, Microsoft Access MVP


Douglas J. Steele said:
Any reason for not just using

=DAvg("[NoDays]","MyTable")

The Help file says "Records containing Null values aren't included in the
calculation of the average"

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Klatuu said:
=DSum("[NoDays]","MyTable") / DCount("*", "MyTable", "NoDays Is Not Null")
--
Dave Hargis, Microsoft Access MVP


Guillermo said:
An examply to "Subject: Calculate the average number of days (Access data
base)"
posted this morning.

Agreement Number Nodays
99363154553 12
94474282 11
9311802 10
98512292721365 7
48482632 6

This my table. I need to sum the number of days (46) and calculate the
average.
46 divided by the number of rows (5) -> 9.2. Easy mental arithmatic, but
how
do I do it in ACCESS?
Click to expand...
Click to expand...
Click to expand...
 
Yeah, I know. You're paid by the keystroke, aren't you? <g>

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Klatuu said:
Yes, I have a very good reason.

I didn't think about it. <g>
--
Dave Hargis, Microsoft Access MVP


Douglas J. Steele said:
Any reason for not just using

=DAvg("[NoDays]","MyTable")

The Help file says "Records containing Null values aren't included in the
calculation of the average"

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Klatuu said:
=DSum("[NoDays]","MyTable") / DCount("*", "MyTable", "NoDays Is Not
Null")
--
Dave Hargis, Microsoft Access MVP


:

An examply to "Subject: Calculate the average number of days (Access
data
base)"
posted this morning.

Agreement Number Nodays
99363154553 12
94474282 11
9311802 10
98512292721365 7
48482632 6

This my table. I need to sum the number of days (46) and calculate the
average.
46 divided by the number of rows (5) -> 9.2. Easy mental arithmatic,
but
how
do I do it in ACCESS?
Click to expand...
Click to expand...
Click to expand...
 
LOL (I have been found out)
Thanks, Doug.
--
Dave Hargis, Microsoft Access MVP


Douglas J. Steele said:
Yeah, I know. You're paid by the keystroke, aren't you? <g>

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Klatuu said:
Yes, I have a very good reason.

I didn't think about it. <g>
--
Dave Hargis, Microsoft Access MVP


Douglas J. Steele said:
Any reason for not just using

=DAvg("[NoDays]","MyTable")

The Help file says "Records containing Null values aren't included in the
calculation of the average"

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


=DSum("[NoDays]","MyTable") / DCount("*", "MyTable", "NoDays Is Not
Null")
--
Dave Hargis, Microsoft Access MVP


:

An examply to "Subject: Calculate the average number of days (Access
data
base)"
posted this morning.

Agreement Number Nodays
99363154553 12
94474282 11
9311802 10
98512292721365 7
48482632 6

This my table. I need to sum the number of days (46) and calculate the
average.
46 divided by the number of rows (5) -> 9.2. Easy mental arithmatic,
but
how
do I do it in ACCESS?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top