Hi!
I have a calculated field in a query - DaysTilDue1: IIf([Completed]=True,99999,[Report Due Date]-Date())
I want the query to prompt for how many days due and give me the reports due for the days <= that number. For example if they want to see reports due within 45 days - they would enter 45 and get the reports due within 45 days. I can't get his to work. I tried <=[Days Til Due?]. it prompts for the number of days but the results are not what I want.
Please help.
Thanks!
Sherry