Report showing yes/no for overdue

[joannek333a]

Hi there,

I am trying to create a column on a report that displays yes or no for records 30 days past the Complete by Date. I am not sure the best way to do this. Can someone help me?

Thanks,

Joanne

[comteck]

Do you want a box to become visible that gives you the option of yes/no, or do you want "Yes" to be selected automatically for one criteria and "No" for another?

comteck

[joannek333a]

I would just like "yes" to be selected automatically for one criteria and "no" for another...

thanks :-)

[comteck]

Create 2 checkboxes on your report, one for "Yes", and one for "No". Open the properties for the "Yes" checkbox, and under Control Source, type the following:

=IIf([CompleteDate]<=(Date()-30),True,False)

Open the properties for the "No" checkbox, and type the following:

=IIf([CompleteDate]>(Date()-30),True,False)

And, yes, there are 2 I's in IIf.

Hope this helps.
comteck