Writing a query that will show past due orders

[ccoffelt]

I need to write a query that shows all of my open work orders thus far. I did that with no problem. However, I also need to show what work orders are past due. For example, if today's report date is 1/17/06 on the Work Order and it is still open on 1/24/06 then it is 1 week past due. And if it is still open on 1/31/06 then it is 2 weeks over due. Etc. I haven't used Access in forever and can not figure out how to do this. If any one can help I would be greatly appreciative. Thanks

 

[dhookom]

Is the [report date] the due date? What defines "over due vs past due? Do you only want to show the record or do you want them to be grouped? Do you have sample sample records and desired output?

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]

 

[OmandA]

As 'dhookom' states we likely need more data before we can answer fully however you'll probably be looking to add a column to your query sort of like this:

DaysPastDue: IIF(Date() - [ReportDate] > 0,Date() - [ReportDate],0)