How do I show the criteria that a query has been run against. The criteria are not pop-up parameters for the report like start-date & end-date, but criteria in the underlying query.
Inexact Example: If we need separate reports of widget sales forfield-salesmen and retail-counter between [start-date] and [end-date], I may create different reports titled TOTAL SALES, but I would like to show in the header the exact criteria used in the underlying queries of the reports, so that my report headers might look like:
TOTAL SALES between [1/1/2002] and [12/31/2002]
Region: Southern States
AccountRep: Is Not Null
TOTAL SALES between [1/1/2002] and [12/31/2002]
Region: Southern States
AccountRep: Is Null
TOTAL SALES between [1/1/2002] and [12/31/2002]
Region: Northern States
AccountRep: Is Not Null
TOTAL SALES between [1/1/2002] and [12/31/2002]
Region: Northern States
AccountRep: Is Null
My inexact example is, of course, inexact. I understand how pop-up params work, and the queries are much more complex than they would be practical for. For audit or verification purposes, it is useful to show the actual criteria used for deriving the results shown, and I’m sure there must be a way to do this (I hope!). No MS Access parameters answers please. MS KB articles 209250 and 304353 are not what I am looking for. What I need to be able to do is show the “Is Null” or “Is Not Null” criteria on the report.
Thank you.