Row count

[OraMs]

In ORACLE, you can use ROWNUM to select only a given number of rows. Is there something like this is Access? What is it?

Thanks in advance.

 

[mdthornton]

You can do something like this:

SELECT TOP 25
X, Y
FROM Z
WHERE A = "Something"
ORDER BY B Best Regards,
Mike

 

[OraMs]

Thanks Mike. Now, what if I only want certain columns from the TOP 25 rows?

 

[OraMs]

Mike, please disregard previous message. I got it. Thanks.