top 50 in msaccess ??
-
how do i select limited number of rows in msaccess
like in sql server
select top 50 * from table1?
how in msaccess..
i want to limit the recordset it throws as my db gona increase
<a href="http://www.websolsoftware.com"> For IT jobs click here</a>
*Sukhoi*[font="Arial Narrow"][/font]
-
Did you actually try this???
-
nope!
does it work that way?
how if i add in auto column, and how much max that value can go ?
iam using msaccess in 1 of the website, which has heavy data
<a href="http://www.websolsoftware.com"> For IT jobs click here</a>
*Sukhoi*[font="Arial Narrow"][/font]
-
There's a simple reason you don't get much help around here. TRY FOR YOURSELF first, then if all fails come back here. Check the access help for that info, it's all there.
It's not the first time you do this, but I hope it's the last.
-
uff it works, but i guess i had tried this feature, but it didn't work.
now its working in 2003, maybe some syntak err was there when i tried it
thanks
<a href="http://www.websolsoftware.com"> For IT jobs click here</a>
*Sukhoi*[font="Arial Narrow"][/font]
-
Dude, works with 2k... and most likely much earlier.
-
Yeah, all the way back to Acc97.
----------------
Jim P.A little bit of this and a little byte of that can cause bloatware.
-
Thanx for the info... However I'm glad I won't be needing to use it someday
.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply