Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: jmshik
  • Content: Threads
  • Order by date
  1. jmshik

    Access table deleting 5 out of 6 records

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

    Excel Ms Query German Week Nos

    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?
  3. jmshik

    Iif isnull doesn't return 0 values

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

Part and Inventory Search

Back
Top