|
| 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
May 27th, 2010, 10:41 PM
posted to microsoft.public.access
|
|||
|
|||
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 | |
|
|
Threaded Mode