DSum and dates...I need help!

[CBaigent]

Hello, All; thank you for reading.



I am trying to use the DSum function in a query, with the goal of adding all daily temperatures between specified dates. I have spent a solid two days reading and modifying equations, to no avail. My last attempt looked something like this (I am finding conflicting information regarding the use of brackets and quotes); Temp_F is a field in a table and the expression I am attempting to sum, HOBO_Weather_Station_Raw is the domain (a table in my database), and the dates are my criteria. Obviously I am somewhat of a novice...any help you might provide would be so, so, hugely appreciated!

ADD: DSum("[Temp_F]","HOBO_Weather_Station_Raw","[Data_Date]>=#1/1/2016#") - I have also attempted innumerable combinations with/without brackets, quotes, etc.

[orange]

I suggest you tell readers what that SUM represents to you in plain English. We can not suggest HOW until we understand WHAT you are trying to do.

[CBaigent]

"...with the goal of adding all daily temperatures between specified dates"

I have specific blocks of time (defined by calendar dates), within those dates I have daily temperature readings (degrees in Fahrenheit), I would like to find the sum of those temperature readings.

I hope that clarifies what I am after.

[ssanfu]

I would use a totals query, not DSUM() in a query.

Is the date field just the date or is it date and time? If the date field also has the time the following probably won't work.
Might need to create a column in the query that is just the date.

Maybe try:

SELECT Sum(HOBO_Weather_Station_Raw.Temp_F) AS SumOfTemp, HOBO_Weather_Station_Raw.Data_Date
FROM HOBO_Weather_Station_Raw 
GROUP BY HOBO_Weather_Station_Raw.Data_Date
HAVING HOBO_Weather_Station_Raw.Data_Date >=#1/1/2016#;

Here is the query aliased (your table name is LONG!

SELECT Sum(H.Temp_F) AS SumOfTemp, H.Data_Date
FROM HOBO_Weather_Station_Raw H
GROUP BY H.Data_Date
HAVING H.Data_Date >=#1/1/2016#;

------------------------------------------

If the date and time is in the date field, try:

SELECT Sum(HOBO_Weather_Station_Raw.Temp_F) AS SumOfTemp, CDate(Int([Data_Date])) AS OnlyDate
FROM HOBO_Weather_Station_Raw 
GROUP BY HOBO_Weather_Station_Raw.OnlyDate
HAVING HOBO_Weather_Station_Raw.OnlyDate >=#1/1/2016#
ORDER BY ContractDates.Data_Date;

Here is the query aliased

SELECT Sum(H.Temp_F) AS SumOfTemp, H.CDate(Int([Data_Date])) AS OnlyDate
FROM HOBO_Weather_Station_Raw H
GROUP BY H.OnlyDate
HAVING H.OnlyDate >=#1/1/2016#;
ORDER BY ContractDates.Data_Date;

Warning:
These queries are untested!!!

[orange]

Hmmm...

I would like to find the sum of those temperature readings.

I'm curious--what will you do with the sum of several temperatures?

You might consider Avg. Just a guess. Good luck.