I am trying to do a REPORT LABEL for some records. I have researched and tried to figure out the best way to do this, but have been unable to. I have a table that has a LAST USED date for an account. I want to do a search for the accounts that have a LAST USED date that is less than or equal to the past 120 days from the date entered into the textbox. Then I want it to be printed into my REPORT LABEL, which I have laid out already. I attempted to create a procedure to do it, but it did not work. I was thinking to do a DO CASE or SCAN. Any suggestions on how to go about it.

Thanks!!!

Adam