How to Get Particular Records from ACCESS

H

humptydumpty

Hello my database looks like

Name Age
Hello 21
Hi 25
Bye 27
Welcome 16
Say 19
XYZ 18

Now i want to Retrive All the record between Row 3 to Row 6 How i can do
that In Microsoft Access.
 
J

John Spencer

You can't. There is no such thing as a row number in Access records,

If you can specify what makes the third to sixth posted example records
different from the other records you have posted, then you can select the
specific records based on the criteria.

For instance none of the records you want has a name that starts with the
letter H. You could use that as the criteria. Or you could use Age where Age
is less than 21 and greater than 25.

John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
 
Top