I would like to limit the number of returns from my query to 350. Can anyone please tell me how to do this is Access 2010?
(SQL or Design View)
Thanks.
2 results in 0.0013 seconds.
-
How do I limit the returns from a query?
-
Why im getting wrong number of rows when using group by and limit?
Hi everybody, i'm doing a query where i want retrieve some records when i do the query without 'limit' the result returns me the correct number of rows, but when i use limit the result returns me the half of the rows. the query im using is something like this:
...Code:SELECT WGI_TaxoName.ScientificName, WGI_Locality.Locality, IFNULL(CONCAT(GROUP_CONCAT(IFNULL(CONCAT(wgi_agent.lastname,", ",wgi_agent.firstname),wgi_agent.lastname)
