4 Replies Latest reply on Jul 20, 2017 6:21 AM by beverly

    MS Query date Criteria

    philthomasp

      I have a query that I have created that I am having a strange issue with. First, the details:

       

      Filemaker server is installed on a Mac server

      ODBC connection is being made using a Windows 10 PC and MS Excel/Query

       

      When I build my query everything is great until I add a date criteria. As soon as I add one and send the data to Excel, I can no longer edit said query. When I want to edit it from Excel, query opens but all I see is the data, I cannot do anything else to the table UNTIL I open the SQL box and manually delete the Date script.