| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
|
|
|
||
|
|
| |
|
Guest
Posts: n/a
|
|
|
|
|
||
|
Guest
Posts: n/a
|
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 http://I.Am/DougSteele (no e-mails, please!) "Klatuu" <(E-Mail Removed)> wrote in message news  28704DD-DE2E-4F90-965E-(E-Mail Removed)...> =DSum("[NoDays]","MyTable") / DCount("*", "MyTable", "NoDays Is Not Null") > -- > Dave Hargis, Microsoft Access MVP > > > "Guillermo" wrote: > >> 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? >> |
|
|
|
|
|||
|
Guest
Posts: n/a
|
Yes, I have a very good reason.
I didn't think about it. <g> -- Dave Hargis, Microsoft Access MVP "Douglas J. Steele" wrote: > 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 > http://I.Am/DougSteele > (no e-mails, please!) > > > "Klatuu" <(E-Mail Removed)> wrote in message > news 28704DD-DE2E-4F90-965E-(E-Mail Removed)...> > =DSum("[NoDays]","MyTable") / DCount("*", "MyTable", "NoDays Is Not Null") > > -- > > Dave Hargis, Microsoft Access MVP > > > > > > "Guillermo" wrote: > > > >> 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? > >> > > > |
|
|
|
|
|||
|
Guest
Posts: n/a
|
Yeah, I know. You're paid by the keystroke, aren't you? <g>
-- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Klatuu" <(E-Mail Removed)> wrote in message news:A9D30EBE-CED2-4576-8ADB-(E-Mail Removed)... > Yes, I have a very good reason. > > I didn't think about it. <g> > -- > Dave Hargis, Microsoft Access MVP > > > "Douglas J. Steele" wrote: > >> 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 >> http://I.Am/DougSteele >> (no e-mails, please!) >> >> >> "Klatuu" <(E-Mail Removed)> wrote in message >> news 28704DD-DE2E-4F90-965E-(E-Mail Removed)...>> > =DSum("[NoDays]","MyTable") / DCount("*", "MyTable", "NoDays Is Not >> > Null") >> > -- >> > Dave Hargis, Microsoft Access MVP >> > >> > >> > "Guillermo" wrote: >> > >> >> 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? >> >> >> >> >> |
|
|
|
|
|||
|
Guest
Posts: n/a
|
LOL (I have been found out)
Thanks, Doug. -- Dave Hargis, Microsoft Access MVP "Douglas J. Steele" wrote: > Yeah, I know. You're paid by the keystroke, aren't you? <g> > > -- > Doug Steele, Microsoft Access MVP > http://I.Am/DougSteele > (no e-mails, please!) > > > "Klatuu" <(E-Mail Removed)> wrote in message > news:A9D30EBE-CED2-4576-8ADB-(E-Mail Removed)... > > Yes, I have a very good reason. > > > > I didn't think about it. <g> > > -- > > Dave Hargis, Microsoft Access MVP > > > > > > "Douglas J. Steele" wrote: > > > >> 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 > >> http://I.Am/DougSteele > >> (no e-mails, please!) > >> > >> > >> "Klatuu" <(E-Mail Removed)> wrote in message > >> news 28704DD-DE2E-4F90-965E-(E-Mail Removed)...> >> > =DSum("[NoDays]","MyTable") / DCount("*", "MyTable", "NoDays Is Not > >> > Null") > >> > -- > >> > Dave Hargis, Microsoft Access MVP > >> > > >> > > >> > "Guillermo" wrote: > >> > > >> >> 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? > >> >> > >> > >> > >> > > > |
|
|
|
|
|||
|
|
| |
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Obtaining Forward EndDate with StartDate and Number of Days e.g. 30 (Number of days(30) excludes weekends and holidays | Microsoft Access Forms | 1 | 10th Sep 2009 06:25 PM | |
| Calculate the average number of days (Access data base) | Guillermo | Microsoft Access VBA Modules | 0 | 29th Jul 2008 11:50 AM |
| Add a number of days to a date in access | =?Utf-8?B?anVuaW9y?= | Microsoft Access Forms | 1 | 9th Mar 2005 12:08 AM |
| calculate number of working days in an access date range | =?Utf-8?B?R2FycnlE?= | Microsoft Access Queries | 1 | 13th Dec 2004 01:00 PM |
| Access Number of Days Query | Morena | Microsoft Access VBA Modules | 2 | 9th Sep 2003 07:07 PM |
