Search results

  1. M

    Date format for WHERE clause

    I'm converting an Access project (adp) over to a linked table (accdb) front end with an ODBC connection to the SQL Server data and am having problems opening reports that have date criteria in their WHERE clause. I've tried the following syntax in the WHERE clause: ReportDate > #dd/mm/yyyy#...
  2. M

    My intro

    Hi I live in Hampshire UK and work for a small(ish) company in West Sussex. I have been developing with Access for about 20 years, so I started with Access 7.0. I almost exclusively use it as a front end hooked up to SQL Server databases. I'm also the DBA and developer for the back end data...
Back
Top Bottom