标签云

微信群

扫码加入我们

WeChat QR Code


Will the same work for an optional GROUP BY?

2018年09月25日22分43秒

Chad I am not sure what you mean, perhaps PARAMETERS ParamA Text ( 255 ); SELECT IIf(IsNull([ParamA]),"*",[ParamA]) AS Expr1, t.id FROM table1 AS t GROUP BY IIf(IsNull([ParamA]),"*",[ParamA]), t.id HAVING (((t.id) Like IIf(IsNull([ParamA]),"*",[ParamA])));

2018年09月25日22分43秒

Actually, the wildcard will also depend on what data interface you're using. In SQL executed via ADO against SQL Server, you use "%" instead of the Jet SQL "*", for instance.

2018年09月26日22分43秒

Actually, Jet has two wildcards: "%" in ANSI-92 Query Mode and "*" in ANSI-89 Query Mode. ADO is always ANSI-92, DAO is always ANSI-89 and the Access interface can be either. You may not be aware of this because you always use DAO.

2018年09月26日22分43秒

Air link now fixed.

2018年09月25日22分43秒

Thanks. I was having the darndest time finding a current URL that seemed to have the described content - but maybe there isn't one. Can't find much info about to what extent this is an issue in 2010 and later versions of Access, either.

2018年09月26日22分43秒