帮忙把一句sql求id最大值转换成access
帮忙把sql转换成access
SQL:select isnull(max(ArticleId),0) as newIDValue from Article
ACCESS:?
[解决办法]
try this,
select iif(isnull(max(ArticleId)),0,max(ArticleId)) as newIDValue from Article