Re: Limit Table Records

From: Andy (pchelp_at_wtcinformme.com)
Date: 07/12/04


Date: Mon, 12 Jul 2021 09:01:13 -0400

John;

Thank You for Your reply.

Know about the query to retrieve information.

What I'm trying to do is limit the input of a table.

Andy

"john smith" <someone@microsoft.com> wrote in message
news:e5yiSG9ZEHA.1152@TK2MSFTNGP09.phx.gbl...
> 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
> >
> >
> >
>
>