Average Number of Days

[ptrifile]

I have a very simple database that simply houses company name, date ordered and item ordered. What would be the simplest way to get the average number of days in between each order by company by product? Any help or suggestion would be appreciated.

Thanks!

Paul

 

[ProgramError]

You should be looking at the avg() function.

Program Error
Programmers do it one finger at a time!

 

[ptrifile]

I have tried using the avg() function but cant seem to figure out how to get # of days, all i come up with is a date not number of days. any suggestions?

Paul

 

[rssql]

DateDiff(myfirstdate, myseconddate)