flag in access

[bold01]

Hi everyone,



I have a task to create something in access table.

I sort of need an update on fields in column "time scheduled" to reflect on fields in column "tolerance" such that

IF field "time completed" is blank, then field "tolerance" should be red.

IF date difference between field "time schedule" and field "time completed" is greater or equal to 7,then field "tolerance" should be RED, else Green.

I know this could be done using macro or Visual basic but am not so conversant with their use. someone please help me....Thanks

[pbaldy]

The simplest tool for what you want to do is called Conditional Formatting, available on both forms and reports. Play with it and see if you get your result.

[bold01]

thanks for your reply pbaldy, i'll sure give it a try and hope i'll get what i want.

bold01

[pbaldy]

No problem, and post back if you get stuck. Welcome to the site by the way!

[bold01]

thanks really. I used the conditional formating and it did worked :-) however, i still don't know how to go about making a field calculate the difference between two dates in another fields. more help would be appreciated on this

bold01

[pbaldy]

I don't have 2010 in front of me, but this should still work. You'd use Expression Is instead of Field Value Is, with an expression like:

DateDiff("d",[OneField],[TheOtherField])>7

[bold01]

thanks pbaldy, you've been of great help. i finally did it before i got your mail. I simply did the calculation in the query using Difference: Round([date1]-[date2], 2) and it worked. thanks anyway. But the last part now is to make the null fields turn red using conditional formatting. what expression do you think i could apply on this? thanks

bold01

[pbaldy]

I use Expression Is and an expression like:

IsNull([txtReqDate])

[bold01]

perfect. that did it thanks.

[pbaldy]

No problem, and welcome to the site by the way!