1 Reply Latest reply on Nov 6, 2013 6:54 AM by philmodjunk

    Limit search results to a set number of records - How?

    oldgit

      Title

      Limit search results to a set number of records - How?

      Post

           I have a large database and wish to search for the first x number of records.

           In SQL, my query would be something like

           "SELECT field1, field2 FROM table1 WHERE dateField >= today ORDER BY dateField LIMIT 10"

           Is it possible to limit the results similarly in FMP?

           Thx