从表单中过滤多个字段以打开报告
MS Access数据库：我有一个报告，我想从具有多个过滤器字段的表单中打开。单独使用时，每个过滤器都可以正常工作。当我尝试结合它们时，它们不起作用。
DoCmd.OpenReport "Lessons Learned", acViewReport, , "Customer = '" & CustName & "'"
DoCmd.OpenReport "Lessons Learned", acViewReport, , "Phase = '" & ProjectPhase & "'"
当我尝试将它们结合在一起时，我会遇到错误，
DoCmd.OpenReport "Lessons Learned", acViewReport, , "Phase = '" &ProjectPhase&"'" And "[Customer] = " & CustName& "'"
我一直在尝试解决这个问题。谢谢
MS Access Database: I have a report that I want to open from a form with multiple filter fields. Each filter works fine when used individually. They do not work when I try combining them.
DoCmd.OpenReport "Lessons Learned", acViewReport, , "Customer = '" & CustName & "'"
DoCmd.OpenReport "Lessons Learned", acViewReport, , "Phase = '" & ProjectPhase & "'"
When I try combining them with AND, I get errors
DoCmd.OpenReport "Lessons Learned", acViewReport, , "Phase = '" &ProjectPhase&"'" And "[Customer] = " & CustName& "'"
I have been trying to resolve this for weeks. Thank you
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论