Table reset

[thenewone]

Hello

I am trying to reset two column in a access table and set them to zero.

I am wrote this little bit of code
it work for the rebates cloumn but not rebates %

any help will be great
thanks

Sub Command102_Click()

Dim strSQL As String
strSQL = "UPDATE pricing SET pricing.rebates = 0;"
strSQL = "UPDATE pricing SET pricing.rebates % = 0;"
DoCmd.RunSQL strSQL


End Sub

 

[dhannant]

I'm pretty sure you need brackets surrounding that statement. The space is probably throwing it off. Try:

Sub Command102_Click()

Dim strSQL As String
strSQL = "UPDATE pricing SET pricing.rebates  = 0;"
strSQL = "UPDATE pricing SET pricing.[rebates %] = 0;"
DoCmd.RunSQL strSQL


End Sub