Equipment Not Worked on.

["McCown, Larry" <MCCOWLA@MAIL.NORTHGRUM.COM>]

Hi all,
Here is one that has stumped me all week.
I have a monthly report that identifies work orders created within Maximo
for specific pieces of equipment within user input date ranges.  And this is
working fine.
I have now been tasked to identify if any of these pieces of equipment had
no work done during the user input time frame.  I have looked at using not
between in the date range but then I get all the work orders outside the
date range.
Sqlbase, sqr version 3, application Maximo.

 <<FORM6.SQR>>

Any suggestions will be appreciated.
Thank you
                                Larry
                                Larry McCown
                                Northrop Grumman
                                One Northrop Ave.          WG20/51
                                Hawthorne, CA. 90250
                                e-mail MccowLa@mail.northgrum.com
                                (310)332-8360  fax (310)332-4913
                                N

FORM6.SQR