|
| 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
June 2nd, 2010, 02:30 PM
posted to microsoft.public.access.queries
|
|||
|
|||
SQL Update question
Good morning,
I have 3 fields [printtab], [rotation], & [adn]. Rotation and adn are True/False fields. The printtab is a number field. In stead of having 3 SQL statements, I'd like to update the fields like this: strSQL = "UPDATE tblconfig SET [rotation] = True, [printtab] = 1, [adn] = True" '************* Updates the Config File ************* CurrentDb.Execute strSQL, dbFailOnError When I tried it it kept on giving me errors. Error:3061. Too few parameters. Expected 1. Can it be done like above or do I need to use 3 SQL statements? Thank you for your input. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...eries/201006/1 
|
| Thread Tools | |
| Display Modes | |
|
|
Threaded Mode