Time and Minimums

[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

 

[KARL DEWEY]

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.

 

[MGFoster]

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.

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Try this:

SELECT temp_date, temp
FROM Temps As T
WHERE temp = (SELECT Min(temp) FROM Temps
WHERE DateValue(temp_date) = DateValue(T.temp_date))

HTH,
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBSkULMoechKqOuFEgEQIiMQCfYrLTbRrOmSPeN+3lA5zRdbirougAoJZD
IE029tkPcoBWHtRChd72HEje
=I7R7
-----END PGP SIGNATURE-----

 

[genisse05]

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

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

 

[KARL DEWEY]

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

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

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

 

[genisse05]

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]));

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

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

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