Hello to everyone.
I was programming on an Access's database.
Biggest issue is that i have to round off some values in a very nasty way.
Now, the rounding off subroutine is ok and works. I have called it Allineamento.
Datas are got from a table and pulled in Elenco which is a summary box.
lisagros is the field that i want to change using my sub-routine.
What doesn't work is the Update sql.
Here is the code:
Private Sub Comando0_Click()
For i = 0 To Elenco.ListCount - 1
Test = Allineamento(Elenco.Column(5, i) * 30 / 100 + Elenco.Column(5, i))
lisagros.Value = Test
SQL = "UPDATE Arrotondamenti SET lisaros=" & lisagros.Value & "WHERE Price=" & Elenco.Column(5, i)
DoCmd.RunSQL SQL
Next
End Sub
Any clue of why it doesn't work?