Last operation help

Thanks for all the direction it has givin me a new path to follow.

My ultimate goal is to be able to look at a job and be able to determine

The date the order was eneterd = OrderHead.Orderdate
The date the first WCC setup operation was logged = ?
The date the first WCC Production Time was logged = ?
The date the last WCC Production Time was logged =?
The date the last Inspection time was logged =?
The date the parts Shipped = Shiphead.Shipdate
The date the Job was closed = Jobhead.Closedate
the date the order was closed = Orderhead.closedate

Basicly I am working on a lead time report using the standard table
fields. I could use some direction on to grap the production dates.

Has any one tackled a report like this?

Thanks

Jim