I am trying to design a report that will group records based on date range parameters.
There is a WORK ORDER table joined to a TIME CHARGES table by the WORK ORDER NUMBER.
I need to indicate the work order as completed based on when time was entered into the TIME CHARGES table.
For example:
work order # 123456 has time dates of
6/1/2004, 6/5/2004
work order #123458 has time dates of
6/1/2004, 7/3/2004
I need to indicate that all work orders that have the maximum time dates from 6/1/2004- 6/30/2004 as 'Complete'
and all others as 'Not Complete'
Any ideas would be appreciated.
There is a WORK ORDER table joined to a TIME CHARGES table by the WORK ORDER NUMBER.
I need to indicate the work order as completed based on when time was entered into the TIME CHARGES table.
For example:
work order # 123456 has time dates of
6/1/2004, 6/5/2004
work order #123458 has time dates of
6/1/2004, 7/3/2004
I need to indicate that all work orders that have the maximum time dates from 6/1/2004- 6/30/2004 as 'Complete'
and all others as 'Not Complete'
Any ideas would be appreciated.