I have a report that has a formula as shown below.
Can show the date criteria in the report as shown in the text between the brackets [Enter Days in Future]?
For example, the report opens and the user enters the days criteria (ie 30) and I would like this same number to show in the title of the text somehow "Past Dues within 30 days"
Possibly the best way to do this is to have an input form that pops up and asks for the days in the future instead of having the criteria within the query and make reference to the pop up form with the days field.
here is the formula:
Between Date() And Date()+Nz([Enter Number of Days in Future],100000) Or Is Null