Time and Minimums

  • Thread starter Thread starter genisse05
  • Start date Start date
G

genisse05

I have around 54,000 rows of data, that consists of a time stamp and
temperatures. I need to find the minimum on each day and at what time that
occured. When I run the AutoCalc to find the minimum (temperature) it changes
all of my time stamps to the exact same time everyday.

Any suggestions on how to get around this issue would be greatly appreciated.

Bea
 
Name this query DateMinTemp
SELECT DateValue([YourTimeField]) Min([Temperature]) AS Min_Temp
FROM YourTable
GROUP BY DateValue([YourTimeField]);

SELECT YourTimeField, Temperature
FROM DateMinTemp LEFT JOIN YourTable ON (DateMinTemp.Min_Temp =
YourTable.Temperature) AND (DateValue(DateMinTemp.YourTimeField) =
DateValue(YourTable.YourTimeField));

If there are multiple times in a day that were at the minimum temperature it
will display all of them.
 
I don't know if it is my table, but when I try to run the query it tells me
that there is a syntax error (Missing operator) on the 'SELECT' row.

SELECT DateValue([Time]) Min([temp - 10cm]) AS Min_Temp
FROM Balda
GROUP BY DateValue([Time]);

Thanks for responding.

Bea


KARL DEWEY said:
Name this query DateMinTemp
SELECT DateValue([YourTimeField]) Min([Temperature]) AS Min_Temp
FROM YourTable
GROUP BY DateValue([YourTimeField]);

SELECT YourTimeField, Temperature
FROM DateMinTemp LEFT JOIN YourTable ON (DateMinTemp.Min_Temp =
YourTable.Temperature) AND (DateValue(DateMinTemp.YourTimeField) =
DateValue(YourTable.YourTimeField));

If there are multiple times in a day that were at the minimum temperature it
will display all of them.

genisse05 said:
I have around 54,000 rows of data, that consists of a time stamp and
temperatures. I need to find the minimum on each day and at what time that
occured. When I run the AutoCalc to find the minimum (temperature) it changes
all of my time stamps to the exact same time everyday.

Any suggestions on how to get around this issue would be greatly appreciated.

Bea
Click to expand...
Click to expand...
 
I omitted a comma --
SELECT DateValue([Time]), Min([temp - 10cm]) AS Min_Temp
FROM Balda
GROUP BY DateValue([Time]);


genisse05 said:
I don't know if it is my table, but when I try to run the query it tells me
that there is a syntax error (Missing operator) on the 'SELECT' row.

SELECT DateValue([Time]) Min([temp - 10cm]) AS Min_Temp
FROM Balda
GROUP BY DateValue([Time]);

Thanks for responding.

Bea


KARL DEWEY said:
Name this query DateMinTemp
SELECT DateValue([YourTimeField]) Min([Temperature]) AS Min_Temp
FROM YourTable
GROUP BY DateValue([YourTimeField]);

SELECT YourTimeField, Temperature
FROM DateMinTemp LEFT JOIN YourTable ON (DateMinTemp.Min_Temp =
YourTable.Temperature) AND (DateValue(DateMinTemp.YourTimeField) =
DateValue(YourTable.YourTimeField));

If there are multiple times in a day that were at the minimum temperature it
will display all of them.

genisse05 said:
I have around 54,000 rows of data, that consists of a time stamp and
temperatures. I need to find the minimum on each day and at what time that
occured. When I run the AutoCalc to find the minimum (temperature) it changes
all of my time stamps to the exact same time everyday.

Any suggestions on how to get around this issue would be greatly appreciated.

Bea
Click to expand...
Click to expand...
Click to expand...
 
Thanks!
The DateMinTemp worked.

This script when run is asking me for a time parameter? I added the
brackets, because it was telling me that there were missing operators. Is
there a way that I can have it run without me having to give a time parameter?

Thanks so much for everything else

Bea

SELECT Time, [10cm]
FROM DateMinTemp LEFT JOIN Balda3 ON (DateMinTemp.[Min_Temp] =
Balda3.[10cm]) AND (DateValue(DateMinTemp.[Time]) = DateValue(Balda3.[Time]));

KARL DEWEY said:
I omitted a comma --
SELECT DateValue([Time]), Min([temp - 10cm]) AS Min_Temp
FROM Balda
GROUP BY DateValue([Time]);


genisse05 said:
I don't know if it is my table, but when I try to run the query it tells me
that there is a syntax error (Missing operator) on the 'SELECT' row.

SELECT DateValue([Time]) Min([temp - 10cm]) AS Min_Temp
FROM Balda
GROUP BY DateValue([Time]);

Thanks for responding.

Bea


KARL DEWEY said:
Name this query DateMinTemp
SELECT DateValue([YourTimeField]) Min([Temperature]) AS Min_Temp
FROM YourTable
GROUP BY DateValue([YourTimeField]);

SELECT YourTimeField, Temperature
FROM DateMinTemp LEFT JOIN YourTable ON (DateMinTemp.Min_Temp =
YourTable.Temperature) AND (DateValue(DateMinTemp.YourTimeField) =
DateValue(YourTable.YourTimeField));

If there are multiple times in a day that were at the minimum temperature it
will display all of them.

:

I have around 54,000 rows of data, that consists of a time stamp and
temperatures. I need to find the minimum on each day and at what time that
occured. When I run the AutoCalc to find the minimum (temperature) it changes
all of my time stamps to the exact same time everyday.

Any suggestions on how to get around this issue would be greatly appreciated.

Bea
Click to expand...
Click to expand...
Click to expand...
 
Back
Top