AnsweredAssumed Answered

Select statement to compare values within same field

Question asked by RGBWebDevelopment on Nov 4, 2016
Latest reply on Nov 7, 2016 by bixb0012

I need help creating a select statement for an attribute table of temperature data. The table has fields for Station_Name, Date and Max_Temp and I would like to select only those records where the temperature difference between weather stations was 20 degrees or more in the same day. I'm stumped on how to compare the 18 Max_Temp values in any single day for each of 365 Dates.

Outcomes