How can I limit the results extracted by a query in Acces? <p>I have this query in my Access database:</p> <pre><code>SELECT t_Campioni_CAMPIONE, t_Campioni.[DATA ARRIVO], t_Campioni.PRODUTTORE, t_Campioni.CodF, t_Fornitori.[Nome Fornitore] FROM t_Campioni INNER JOIN t_Fornitori ON t_Campioni.CodF = t_Fornitori.CodF WHERE (((t_Campioni.CAMPIONE)=[Forms]![m_Campioni_modifica]![CAMPIONE])) ORDER BY t_Campioni.[DATA ARRIVO] DESC; </code></pre> <p>It works but I need it to extract only the first record (with the last date). How can I do it?</p>