[RESOLVED] ADO VB6 Access DB

[Ricky1]

ok VB 6 with a Access Database using ADO

I have an autonumber fields which puts my records in the order i require them.

I just need pointing in the right direction, wot function to look at etc. What i need to do it, make sure that a few fields are the same and then give me whats in another field and then check the whole database.

Example.

Field "Type" to be "Turbo NL"
Field "Entry Fee" to be "6.00"

then for all the records that have them two (both that is) i want to know whats in the field called "Placed"

Hope this is clear.