Re: Limit Table Records

From: john smith (
Date: 07/12/04

Date: Mon, 12 Jul 2021 15:32:53 +1000

Hi Andy,
The "top x" option can be used with the query to limit the number of rows
Usually it is not used for retrieving just 1 row, but its useable for this
purpose as well.

"Andy" <> wrote in message
> Hi;
> Have been searching for an answer to these two questions for some time.
> Need to limit a sub-form, (displayed as datasheet), to 1 record only, and
> another form need to limit the table it's based on to 5 records.
> Any suggestions?
> Andy