I have not started yet, just doing research first.


In Access I use unconventional methods to obtain the results I need.

I have no formal training in programming so I have to use what I understand as long as it works.

this is how I move thru data to find the records I want:


rsIncidents.MoveFirst
For Z = 1 To rsIncidents.RecordCount
RsIncidents.Absolute position = Z


if RsIncidents("ClientName").value & "" = "Jim Jones" then

'do stuff here

end if



next


I have experimented using the Access filter command and it is no faster.

would Oracle allow me to use similar code to go thru its records??



Does Access 2002 work any better than Access 97??