> 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