Great suggestions.

The Cranes are all the same lift/capacity/size. All have the same left to right movement coverage and distance of travel. the new system optimally is a distance of 500...

Thanks Ratbak. that makes the best sense to me to.

Hi Steve,

The Buildings are on the far ends of all the cranes. we have an older Microwave system that communicates from building A to Crane 1, then daisy chains all...

No problem Jeff. Were it not for Coffee, I would never have survived the 20 years in the Navy!

Jeff, please see the video provided in the LINK. the Big Orange things are the cranes.

https://youtu.be/GjUVDtlPz0c

Thank you Eirikur. I will look into it.

LOL! Ok.

The LPKCX are Cranes. The date and times are the location of the cranes as indicated by the Lat/Long. Calculating the distance between the given LPKCX location and the...

My apologies Phil. I should have included that in the original.

In the DistanceX Columns is the results I am trying to find and only for the Date and times that...

Thank you! that is what I needed. I forgot to add the () around the where clause after the datetime clause.

Jeffrey! Thanks, the Total Failures one I had. I was struggling with the Total Diff.

Thank you ever so much!

Have a great afternoon!

Jeffrey, so talked to the boss. he does want a total failure count and may want a Diff column too later. I will work on that.  If I get stuck,...

Jeffrey, Okay, I removed the FailureCount from the Select and Group By. I also removed Failures from the Order by statement.

That puts it in to a single row. So, now...

Jeffrey, If I remove FailureCount from both the Select and Group By, I get the following error;

Column FailureCount' is invalid in the select list because it is not contained in either...

Jeffrey, I have tried placing the [First of Month], [Middle of Month], [End of Month] in the Group by as it is in the select statement, and have also changed...

Jeffrey, you have been very educational and helpful. I am a little reluctant to ask one more helper question regarding this query set.

Is there a way to combine similar results...

• This reply was modified 2 years, 2 months ago by  brian.cook.