K
kathekas
I have a table called simpleweather, and the 2 fields I am interested in are
datadate which is the date in the format dd,mm,yy hh.mm
outdoors which records the temperature eavery minute
I want to recover the max(outdoors) for each day.
SELECT Left(simleweather.datadate,10) AS Expr1, Max(simpleweather.outdoors)
AS MaxOfoutdoors
FROM simpleweather
GROUP BY simpleweather.datadate;
Please can some assist?
datadate which is the date in the format dd,mm,yy hh.mm
outdoors which records the temperature eavery minute
I want to recover the max(outdoors) for each day.
SELECT Left(simleweather.datadate,10) AS Expr1, Max(simpleweather.outdoors)
AS MaxOfoutdoors
FROM simpleweather
GROUP BY simpleweather.datadate;
Please can some assist?