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.