View Full Version : How to Get Particular Records from ACCESS


humptydumpty
04-23-2008, 02:21 AM
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
04-23-2008, 03:28 AM
You dont unless you have some "identifier" like an autonumber...

Hello 21 <= Row
^
\ Column

I think you are mixing up rows and columns

humptydumpty
04-24-2008, 03:21 AM
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
04-24-2008, 03:29 AM
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.