Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: AMBranch
  • Content: Threads
  • Order by date
  1. AMBranch

    Finding same job done within 6 months on a unit

    I am trying to do a report that shows the same job done on a unit within 6 months of the previous job. Here's my SQL: SELECT b.Unit, b.Job, b.WO, b.[Unit-Job], b.[Unit-Job-WO], b.RepairDate, b!RepairDate-[Repairs]![RepairDate] AS [Delta in Days], [Repairs].WO AS [Previous WO]...

Part and Inventory Search

Back
Top