Avarage time spent on an order?

[Drygast]

I want to calculate the avarage time an order takes to complete.
I put the dates into a accessdatabase (for instance "2003-10-15"), I would
like to pull the dates into a form
where I would like do something roughly like this:

((DateIN)-(DateOut)) and then add up all the results (for instance
5+4+5+4=18) and divide it with the total amount of orders (for instance
18/4=4.5)

Is it possible?

Regards
/Drygast

[Jay B. Harlow [MVP - Outlook]]

Drygast,
Yes its possible!

You can use either a loop in VB.NET to do this, or you could use an SQL
statement in the database.

If you are using the DataSet in VB.NET to hold you data, you can even use
DataTable.Compute method in the calculation of the average.

Hope this helps
Jay

"Drygast" <dr*****@hotmail.com> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...

I want to calculate the avarage time an order takes to complete.
I put the dates into a accessdatabase (for instance "2003-10-15"), I would
like to pull the dates into a form
where I would like do something roughly like this:

((DateIN)-(DateOut)) and then add up all the results (for instance
5+4+5+4=18) and divide it with the total amount of orders (for instance
18/4=4.5)

Is it possible?

Regards
/Drygast