Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to Query Overdue Dates

Status
Not open for further replies.

jchollo

MIS
Joined
Sep 15, 2005
Messages
22
Location
US
I have an action database with a field Due Dates. I named another field Overdue which is currently blank.

I want to figure out one a due date is past, annotate in the Overdue field - 1 day past due, 2 days past due, etc. in red.

How would I configure this query?

tks
 
Tables have fields and queries can't be colored uniquely. You can use a query to display the number of days past due using the DateDiff() function. You can display query results in forms and reports and use conditional formatting to color the controls.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
 
Thanks but how would you write the query. I am not a Access person.

tks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top