I have a table that has a column for "startdate" and "enddate". What I need to find is that for a given range of enddates (july 2- july10), what is the average # of days between the start and end dates. I was able to do this on an Access db using:<BR><BR>strSql ="SELECT SUM enddate FROM Item WHERE enddate BETWEEN (#" & startdaterange & " #) AND (# " & enddaterange & " #) ;"<BR><BR>This would add up all the end dates. I did the same to add all the start dates, subtracted the startsum from the endsum and divided by the record Count. <BR>But on SQL Server this does not behave the same Any ideas?