# Limiting the results on access database

**URL:** <https://forum.kirupa.com/t/limiting-the-results-on-access-database/162404>\
**Category:** Uncategorized\
**Created:** [September 13, 2005, 3:10am UTC](https://forum.kirupa.com/t/limiting-the-results-on-access-database/162404 "2005-09-13T03:10:00Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![SlowRoasted](https://avatars.discourse-cdn.com/v4/letter/s/a698b9/32.png) [@SlowRoasted](https://forum.kirupa.com/u/SlowRoasted)\
**Post date:** [September 13, 2005, 3:10am UTC](https://forum.kirupa.com/t/limiting-the-results-on-access-database/162404/1 "2005-09-13T03:10:00Z")

</div>

Okay i found out that msaccess doesnt support LIMIT in it’s SQL statements. How would I go about only getting one record from a SELECT statement? :-/