If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Update Query
How can I change this code to make the "Occupied" field null? This is just a
small part of a larger peice of code but this is whats causing my issue. DoCmd.RunSQL "UPDATE [On Hold Records Table 2] SET [On Hold Records Table 2].Occupied is null" & _ "WHERE ((([On Hold Records Table 2].Identifier)='" & Identifier & "'));" |
Thread Tools | |
Display Modes | |
|
|