Calculate the average number of days (Access data base)

Guillermo

Guest

Posts: n/a

29th Jul 2008

I have a table which holds the number of days a record has been active in
each row. I need to calculate the average number of active days for the whole
table.
Avg function is used on rows/columns. How can I get the average of the total
no of active days?

« link to word no longer working | VBA : how to concatene a list of mails from a form »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Counting average number of days between 2 dates	RobertK	Microsoft Excel Misc	3	19th Sep 2009 02:29 PM
Sum and average number of days and hours	Basenji	Microsoft Excel Misc	4	19th Jan 2009 04:20 PM
Calculate Count of Days & Average WHERE Amount <>0	amg0657	Microsoft Excel Worksheet Functions	1	1st Apr 2008 02:37 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
Average Number of Days	=?Utf-8?B?Y2hyaXNodXRzb24xMjM=?=	Microsoft Access Reports	1	20th Jul 2004 08:26 PM