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!

Recent content by AMBranch

  1. AMBranch

    Finding same job done within 6 months on a unit

    Thanks for both of your help. The first approach gave me an hour glass for a long period of time so I had to abort the run. The second approach yielded too few lines. I will continue to play with it. Thanks again for your help.
  2. AMBranch

    Finding same job done within 6 months on a unit

    Thanks so much for your quick response, I got parameter boxes for a.RepairDate, a.LatestWO, a.LatestRepairDate so I clicked OK for each without putting values in them and then it just gave me an hour glass for a long period of time...I finally had to abort the run. I was wondering about the...
  3. 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]...
See more

Part and Inventory Search

Back
Top