AnsweredAssumed Answered

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

Question asked by oldgit on Nov 5, 2013
Latest reply on Nov 6, 2013 by philmodjunk

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

Outcomes