Sorry about that. I keep forgetting not to use angle brackets... Here's a more legible (I hope) message.
You would say:
LABEL FORM [label] FOR [condition]
In this case, your condition would be something like LastUsed <= [textbox date]-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