parameter query

[Mike Hughes]

I would like to make this part of a query to allow the user to enter the number of days they want to search by.

NOLDBA_CASE_ROLLUP.DT_LAST_PAY)<=Now()-45

I tried NOLDBA_CASE_ROLLUP.DT_LAST_PAY)<=Now()-[days] but this didn’t work

Would someone help please? Thanks Mike

 

[gemma-the-husky]

that looks close to me. what error did you get?

 

[Mike Hughes]

ODBC called failed. I'm connecting to an Oracle table.

 

[Mike Hughes]

I just tried

[NUMBER OF DAYS]<Now()
and worked fine. Thanks for looking