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

    MS Query date Criteria


      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.