Problem with Recordset

[jbkirby via AccessMonster.com]

Let say I have a query with the following result

FieldA FieldB FieldC
jerry 3 5
balce 2 6
kirby 4 6
fortes 3 7
john 4 7
gary 7 8
may 7 7
june 7 7
july 7 7

suppose i want to store the value of the 4th record under FieldA of this
query(='fortes') into a variable,
how can I do this? I tried using recordset but I' having problem with using
this one. I'm using Access2000.

 

[Marco]

Try to use and update filed or add query .

 

[jbkirby via AccessMonster.com]

I mean the value of my variable will be equal to 'fortes' since I want the
fourth record/ FieldA of my query . Why update field?

Try to use and update filed or add query .

Let say I have a query with the following result

[quoted text clipped - 13 lines]

how can I do this? I tried using recordset but I' having problem with using
this one. I'm using Access2000.