求助：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的查询语句不熟，求正确的写法。

[ACMAIN_CHM]

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

[gongshunkai2]

晕死，原来User加个括号，多谢版主，结贴给分了。