I am not exactly sure how your query is set up, but with my problem trying to find the sum of precipitation:
SELECT Sum(IIf(IsNull([precip]) Or [precip]=0,0,1)) AS CtRain
(Thank you, Mr. Watson!)
let me know if this helps!
I have an access table with a DateTime (dd.mm.yyyy hh:mm:ss) primary key, that consists of data, collected every 6 minutes. For several weeks in April, there was some data collected every minute.
I need to strain that data (using SQL) to every 6 minutes as the rest of the table.
Anyone out...
Hi tlbroadbent AGAIN!
This query worked perfect in Access, thank you! But when I attempt to import the result w/MsQuery from Excel, it tells me I can't access the table! I have used msquery, extensively, and never had this problem. I tried creating new queries, in new .mdb's, still the same...
In Access, I am able to derive the German week #'s from an Access table, using datepart, but I can not find a way to do this in MsQuery, as the weeknum function does not facilitate "at least 4 days starting with Monday". Does anyone have a method for doing this from Excel in a query?
I have tried numerous variations of this query, to no avail.
Weather table contains many fields including dates and rain amount per date. I need a result that will list the calendar week, and the count of days that had rain>0, including ALL the week numbers ie: Calendar Wk#18 had no days with...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.