Search results

  1. S

    SQL noob needs help: Finding # of days with data on a date field that includes times

    Ah. I see what you're saying. Minor issue though: No access to Access. Seriously. The organisation I'm contracting for has an IT dept that has a policy that MS-Access is not included in any desktop rollout. I'm working for the finance dept who have a legacy Access Db that is accessed...
  2. S

    SQL noob needs help: Finding # of days with data on a date field that includes times

    Thats a great suggestion, thanks. How do I do that? (SQL noob - only familiar with really basic stuff)
  3. S

    SQL noob needs help: Finding # of days with data on a date field that includes times

    I have an Access Db that lots of automated reports write an error report to with a date/time stamp in the format 'dd-mmm-yyyy hh:mm:ss'. I'm currently pulling stats from this table using the statement "SELECT COUNT(ErrorCode) FROM ErrorsTbl WHERE ErrorReport='" & ReportName & "' AND...
Top Bottom