求助mssql的查询语句换成access怎么写???

[gongshunkai2]

select F.ForumId,F.IsSelected,F.ForumName,F.ForumUrl,F.ForumPr,F.ForumBr,F.ForumNote,(select count(1) from Board where ForumId=F.ForumId) as BrardNumber ,(select count(1) from User where ForumId=F.ForumId) as UserNumber from Forum F order by ForumId

原本是mssql的数据库，现在我要用access数据库，但是同样的语句报错：语法错误，我对access的查询语句不熟，求正确的写法。