access排序问题
SELECT a.FileType, format(sum(a.SheetsPrinted),'0') as PagesPrinted, format(sum(a.Copies),'0') as Copies, Cdbl(format(su(a.TotalCost),'0.00')) as TotalCost FROM prtlog a WHERE a.SiteName='localhost' and a.SubmitTime BETWEEN #2003-01-01 00:00:00# AND #2007-02-06 23:59:59# and a.SheetsPrinted > 0 GROUP by a.FileType order by 'Copies' desc
我想把求和后的结果按指定的列排序,就是Copies,但是有问题,排不了
问题在于order by 'Copies' desc ,请各位指教,谢谢!!!
问题解决,马上给分,信誉第一,从不拖欠。