Hi,
I've got my queries designed just the way they need to be. Now I have to make 'em dynamic based on user selections from a critieria selection form. I have some simple examples books, like for filtering, but it's not enough information.
I understand that I will have to embed my SQL into the...
I have been sooooo frustrated with this nuance of some of my subreports not displaying whenever there is zero (er, null) records returned from said subreports' Count query.
My subreport design properties:
Report: Data: a simple Count query -may sometimes return nothing (er, null)
Hidden...
Hi,
I'm using a count query that in some cases will return zero; meaning no records found. In report preview, it displays #Error instead of zero. How can I make the report display a zero in this case? Hoping to save time with some canned VBA code if anyone has any. Thanks in advance!
-Pete Lyons
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.