Re: How to limit # of rows returned by SELECT
From: <joecool_at_vnet.net>
Date: 1996/03/02
Message-ID: <NEWTNews.825764741.3652.joecool_at_arrakis.vnet.net>#1/1
Date: 1996/03/02
Message-ID: <NEWTNews.825764741.3652.joecool_at_arrakis.vnet.net>#1/1
In Article<3134C77A.2781E494_at_jpmorgan.com>, <gulati_dinesh_at_jpmorgan.com>
writes:
> I guess what he meant above is to have a 'rownum' identity column in the
table.
> But this will work when you have 'rownum < 100' in the where clause. I like
the
> 'set rowcount' option best so far.
This question has already been answered in this thread, how come people are still posting wrong answers?!?
The answer is use the Top property of the Query. See MS-Access help for more info.
Zack Sessions Received on Sat Mar 02 1996 - 00:00:00 CET