How to Get Particular Records from ACCESS

  • Thread starter Thread starter humptydumpty
  • Start date Start date
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.
 
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
 
Back
Top