By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,576 Members | 1,360 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,576 IT Pros & Developers. It's quick & easy.

Avarage time spent on an order?

P: n/a
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
Nov 20 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Nov 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.