> That formats the date for Swedish style format (yyyy-mm-dd)
yyyy-mm-dd is not just swedish, it's ISO standard format
martyn, do the view thing if you can, otherwise your GROUP BY will have to
reflect individual column references
for example, steve's would be
group by DatePart(yyyy,bookDate)
, DatePart(mm,bookDate)
, DatePart(dd,bookDate)
rudy