# I probably should have posted this question in the Programming forum. However, not knowing if there is a non-programming solution, I'll just ask it here first in case I missed something really obvious. #
I have a report that is based on a parameter query. The parameter itself not necessarily equals a field value but rather something to compare the different field values.
The parameter query is:
When I run the report based on this query, I will get all the records satisfying the criteria. However, how do I show on the report what the user has entered as the parameter?
For example, if there is a variaty of TARGE_DATE values in the PROJECT table records including 6/31/2011, 7/20/2011, 7/30/2011 and 8/5/2011. If the user enters "8/1/2011", the report should return projects with the first three TARGET_DATE values but not the last. How do I make that "8/1/2011" show up on the report so that it is obvious to the readers how this report is generated?
Thank you for your help!
I have a report that is based on a parameter query. The parameter itself not necessarily equals a field value but rather something to compare the different field values.
The parameter query is:
Code:
Select * from PROJECTS
where TARGET_DATE <= CDATE([Please enter a date:])
When I run the report based on this query, I will get all the records satisfying the criteria. However, how do I show on the report what the user has entered as the parameter?
For example, if there is a variaty of TARGE_DATE values in the PROJECT table records including 6/31/2011, 7/20/2011, 7/30/2011 and 8/5/2011. If the user enters "8/1/2011", the report should return projects with the first three TARGET_DATE values but not the last. How do I make that "8/1/2011" show up on the report so that it is obvious to the readers how this report is generated?
Thank you for your help!