Conditional Formating Based on Entry Date

[mfaj5]

Hi everyone-

I am working with a sales db. In the db is a continuous subform that consists of a "date" field and a "notes" field.

Because my boss has A.D.D., I added a "Further Action" field to the form. I want to build a query that extracts all of the outstanding "further actions" and puts them in a nice list for him to look at.

In addition, I want to have different colors for the "further actions" depending on how old they are. In the conditional formatting, I can't figure out how to tie in the entry date with the "further action". How do I build that condition?

Any thoughts?

BONUS QUESTION:
How can I create a delete function so that he can check things off when they are done?

As always, any guidance you can provide is greatly appreciated. Keep it simple, too, becuase I just ain't that smart.

-mfaj5

 

[Jack Cowley]

If you are using Access97 then conditional formatting with a continuous form is just about impossible. If you have Access2000 or higher you have access to Conditional Formatting under the Format menu.

I am not clear on your delete question, but you can use a delete query, code or DoCmd.RunCommand acCmdDeleteRecord to delete the record immediately.

hth,
Jack

 

[mfaj5]

I am using Access 2k. I know I can use conditional formatting, but my question is how do I build the condition based on the date of the entry?

For example, how do I tell it to color all "further actioons" older than 5 days to be yellow? And ones older then 10 days become red?

Does that make it any clearer?

 

[Jack Cowley]

Use Field Value Is... Between.... Date()....Date()-n where n is the number of days between the dates.

hth,
Jack

 

[mfaj5]

Alright, I think I am getting closer.

But, here's the dilemma:

There's only one date involved (the date of the call, or the entry), so I can't use BETWEEN. I tried using Field value is greater than NOW()-5, but it colored all "Further actions", not just ones older than 5 days?

Any thoughts?

 

[Jack Cowley]

Between Date() and Date()-5
Between Date()-5 and Date()-10
etc...

Jack

 

[mfaj5]

Jack-

I tried your suggestions. It's still not working.