开发者

In Access 2003 Report, how to hide some detail rows?

I'm working up an MS Access report. This report is grouped and has a details section. But some of these details rows don't need to be shown. How do I hide the details sections if, for example, "[fieldx] = 'foo'"?

(In Crystal Reports, there's a place where you can write custom criteria to su开发者_如何学编程ppress these kinds of things. I can't find an equivalent functionality here in Access).


As David suggested, you could pass WHERE condition to the report:

Function OpenReport(filterValue As String)

DoCmd.Close acReport, "ReportName"
DoCmd.OpenReport "ReportName", acViewReport, "", "[SomeFieldName]<>'" & filterValue & "'", acNormal

End Function
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜