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

Expression Problem with Conditional Formatting

P: 2
I have a database with a Date field, Name field and a checkbox labeled Utilized.

Each record is a request to work an overtime shift.

If a person works overtime, they are checked as utilized...I have sucessfully turned on conditional formatting to make the background red for that person on that particular date. That part was easy.

NOW, what I want to do is for every unique Name which is checked as Utilized within the last 14 days to show up yellow, so that those who have requested, but haven't worked overtime get preference.

I just can't come up with the expression that will make it work.

Any ideas?
Dec 17 '07 #1
Share this Question
Share on Google+
1 Reply

P: 2
My field names are:

OTdate (Short Date Format)
Name (Text) They just enter their first and last names.
Rank (combo-box)
Utilized (Yes/No)

I've tried:

I'm thinking that I have to save the Name text into some type of memory variable and have it look at all of the other records with the same name then finish the expression with:

[Utilized]=True between [Otdate]=date() and [OTdate]=date()-14

I'm just not sure how to get that Name thing to work.
Dec 17 '07 #2

Post your reply

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