Hi We need to produce a query to return the total number of user visits between two date ranges that span over two year e.g from 2009-04-29 to 2010-04-29. My question is how can I compute the totals for each week within a query ? for example
2009-04-29 to 2009-05-06 100 visits 2009-05-07 to 2009-05-14 250 visits etc Cheers Neil