I'm using a SQL statement to update a table called tblMembers. In this table i want to update a field called "No_of_Rentals_at_Present". The following code works perfect but instead of letting it equal to 0, i want to decrease the current calue in the field by 1. I understand i have to change from "=", but i'm unaware what i should change it to.
"strSQL3 = "UPDATE tblMembers SET No_of_Rentals_at_Present = 0 where Member_ID=" & txtVideoMember"
Any help would be grateful.