Re: Limit Table Records

From: john smith (someone_at_microsoft.com)
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
retrieved.
Usually it is not used for retrieving just 1 row, but its useable for this
purpose as well.
John

"Andy" <pchelp@wtcinformme.com> wrote in message
news:%23XFsUa4XEHA.3420@TK2MSFTNGP12.phx.gbl...
> 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
in
> another form need to limit the table it's based on to 5 records.
>
> Any suggestions?
>
> Andy
>
>
>