How to Get Particular Records from ACCESS

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

humptydumpty - 24 Apr 2008 14:15 GMT

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.

Reply to this Message

John Spencer - 24 Apr 2008 14:28 GMT

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

> Hello my database looks like
>
[quoted text clipped - 8 lines]
> Now i want to Retrive All the record between Row 3 to Row 6 How i can do
> that In Microsoft Access.

Reply to this Message