帮忙把一句sql求id最大值转换成access帮忙把sql转换成accessSQL：select isnull(max(ArticleId),0) as newI
帮忙把一句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