sql换成access

显示全部楼层 · 2009-6-12 15:46:04

select lkupJobCategory.item as column1,count([Job]) as column2,convert(varchar,convert(decimal(10,1),(convert(float,count([Job]))/convert(float,(select count([Job]) from BBF)))*100))+'%' as column3 from BBF,lkupJobCategory where lkupJobCategory.itemid=BBF.[Job] and lkupJobCategory.item'' group by lkupJobCategory.item请把这句改成access接受的语句，谢谢！

千问 · 2009-6-12 15:46:04

Select a.item as column1, count([Job]) as column2, Format(count([Job])/(Select count([Job]) From BBF) ,'########.0%') as column3From BBF b,lkupJobCategory a where a.item =b.[Job] and a.item''group by a.item...