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:
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).
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).