Search results for query: *

Elmo, If I am understanding you correctly: SELECT field from table WHERE field between 40 AND 50 Is this what you are asking? jm

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?

Tlbroadbent, THANK YOU!!! You have saved me so much time! jmshik

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...