Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

ms access select query?

4 Posts 2 Posters 0 Views 1 Watching

M Offline
M Offline
murali_utr

wrote on last edited by

#1

hi, I need select query to select number of records(1 to 50 then 51 to 100 from 500 rows)from n rows of selection. not from id I think row id. thanks in advance.

Have A Nice Day! Murali.M Blog
P 1 Reply Last reply

0
M murali_utr

hi, I need select query to select number of records(1 to 50 then 51 to 100 from 500 rows)from n rows of selection. not from id I think row id. thanks in advance.

Have A Nice Day! Murali.M Blog
P Offline
P Offline
PIEBALDconsult

wrote on last edited by

#2

You mean like SELECT TOP 50 ... ?
M 1 Reply Last reply

0
P PIEBALDconsult

You mean like SELECT TOP 50 ... ?
M Offline
M Offline
murali_utr

wrote on last edited by

#3

no any 50 records.

Have A Nice Day! Murali.M Blog
P 1 Reply Last reply

0
M murali_utr

no any 50 records.

Have A Nice Day! Murali.M Blog
P Offline
P Offline
PIEBALDconsult

wrote on last edited by

#4

TOP 50 may be any 50.
1 Reply Last reply

0

Log in to reply