By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,495 Members | 1,076 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,495 IT Pros & Developers. It's quick & easy.

Report showing yes/no for overdue

P: 2
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
Aug 25 '06 #1
Share this Question
Share on Google+
3 Replies


100+
P: 179
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
Aug 25 '06 #2

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

thanks :-)
Aug 25 '06 #3

100+
P: 179
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
Aug 25 '06 #4

Post your reply

Sign in to post your reply or Sign up for a free account.