How to show the user-input value on a report driven by a parameter query?

m3atball

New member
Local time
Today, 15:32
Joined
Mar 4, 2011
Messages
2
# 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:
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!
 
Rather then make the User input into the query, have the query read the data in an unbound text box control on your form.

The query will use the data entered in the form control and the report can also use this control.
 
PNGBILL -

Thank you for the suggestion! That sounds like a flexible way to go.

m3atball
 

Users who are viewing this thread

Back
Top Bottom