help with sql statement

I

ifoundgoldbug

Greetings

I have a table arranged thusly

Reason Status Est Comp Date PMDate Tool#
7/14/06 WFT083
Maintence done 7/16/06 WFT083

what my sql statement MUST do is search by Tool # then find the most
recent PMDate then find if there is a work order with finished
maintence with a complete date AFTER the PMdate. also the returning
record will be a seperate record from the one with the PM date.

thanks for your help.
 

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

help with sql query 2
comparing withing a recordset 1
lotus Notes coding help 2
Problem with complex sql statement underlying a form 1
Calculation of Overlap Outage Hours 17
run time error 3265 help 1
Dates between cells in one column and another 5
Calculating hours missed from actual shift schedule using date/time 1

Top