Recordset Filter

I would like to get minimal value from "Ski" column

Need to use recordset instead Dmin function because this value will be changed many times. I work with dao.recordset but I never used recordset filter

so I need to do something like this:

Code:

---

strSQL = "select tblGoraZleceniaNowaWyceny.id_gora_zlecenia, tblGoraZleceniaNowaWyceny.naklad_pracy, tblGoraZleceniaNowaWyceny.nazwa, tblGoraZleceniaNowaWyceny.Ski, tblMontazSzczegoly.iloscuzytkow from tblGoraZleceniaNowaWyceny inner join tblMontazSzczegoly on tblGoraZleceniaNowaWyceny.id_gora_zlecenia = tblMontazSzczegoly.nazwa where tblGoraZleceniaNowaWyceny.id_wycena_pre=" & Forms!frmWycenyObszarRoboczy!ID_wycena_pre & " order by error desc"

---

Wor = 5

Get the minimum value from strSQL (Ski column)

update this value = Ski+1

wor = wor-1

and loop all procedure until Wor = 0



So the problem is how to requery strSQL to show NEW minium value at the beginning query - rst.requery doesn't work:/



Above it's only example but If I will know how to write above code, then I will solve my problem (which has more complicated meaning to explain).

Recordset Filter