admin管理员组文章数量:1287581
I'm using Dlookup to reference another table; however, now I get a syntax error with COMMAND_ID =
saying that I'm missing an operator.
I also get an error
This expression is typed incorrectly, or it is too complex to be evaluated
My code:
((DLookUp("COMMAND","COMMANDS","COMMAND_ID = " & [TAD_FROM])) Like "*" & [Forms]![MEMBER]![SEARCH_TAD_FROM] & "*"))
ORDER BY MEMBERS.RANK DESC;
I have looked at backed up earlier versions of the query and nothing has been changed from when it worked before. I have also bounced the syntax off of Microsoft's documentation.
本文标签:
版权声明:本文标题:sql - My query has suddenly stopped working. I didn't make any changes but now I get a Dlookup syntax error - Stack Over 内容由网友自发贡献,该文观点仅代表作者本人, 转载请联系作者并注明出处:http://www.betaflare.com/web/1741304310a2371274.html, 本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容,一经查实,本站将立刻删除。
发表评论