How to Get Particular Records from ACCESS

[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 Column 3 to column 6 How i can do that In Microsoft Access

 

[namliam]

You dont unless you have some "identifier" like an autonumber...

Hello 21 <= Row
^
\ Column

I think you are mixing up rows and columns

 

[humptydumpty]

You dont unless you have some "identifier" like an autonumber...

Hello 21 <= Row
^
\ Column

I think you are mixing up rows and columns

My Fault i Am sorry i mean to say between row 3 to row 6

Thanx

 

[namliam]

In what way would you like to select them?
You CANNOT say I want Row 3 to row 6, that simply cannot be done...

IF you have an autonumber field in front then you can say I want Autonumber between 3 and 6, but that is not the same thing.