You would say:
LABEL FORM <label> FOR <condition>
In this case, your condition would be something like LastUsed <=
-120.
>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