Over Due Task query

J

JoeV

Is there an easy way to setup aquery where it will calculate overdue tasks
based on the computer date (I don't want to have to go back in and chage the
statement everytinme I wnat to see what is overdue) Any suggestions
 
K

KARL DEWEY

Use criteria on DueDate like this for those coming due in 3 days --
<Date()+2
Add a criteria to the Completed field that reads Is Null so as not to
pull records that are complete.
 

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

Task Reminders... 1
Date Overdue function, Macro, or VBS 5
Counting Dates in a Query 1
Code to run several queries in series 5
Using Now() in a Query 2
IF Formula to produce coloured statements 4
Query with multiple date fields 1
> 0 4

Top