how Can I caluculate an expired date? 30, 60, 90 (change color)

G

Guest

I was task to build a database to track exercise. The client wants to know
when an employee need schedule a course. The have 30 day after the course
expiration date as being red, 30 before the expiration date as amber, and
anything day longer than 30 as being green. They wanted to also know if I
couldn build an alert message to tell the user someone need to schedule a
class.
 
D

dbahooker

and crosstab queries and buckets

what you're asking for is something called buckets; that's what
programmers call it


-Aaron
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Annotating and expired date 3
Conditional Format where ANY date is >= 30, 60, 90 days EXCEL 2007 1
Format the columns 30 - 60 - 90 -120 5
Age Date Between Two Dates to Return Value as 30, 60, 90 day 2
How to add 30, 60 and 90 days to date and calculate deepening disc 5
Cell color changes when date gets closer 2
Cell colors or text color changing when date in cell gets closer. 5
Colour change by date 2

Top