Updating multiple fields in access
update Table A set Col X = ( select Col X from Table B where Col W = Table A.Col W ), Col Y = ( select Col Y from Table B where Col W = Table A.Note: You cannot run an update query in a Web browser.If you want to run an update query in an Access Web database, you must first open the database by using Access. If you are using an Access web app, you can use data macros to update or change existing data in a set of records.These 3 columns in table A are to be updated based on the values present in table B's corresponding 3 columns, which has the foreign key to primary key in table A.Is there a way to update all the three columns in one shot or another way that update can be done? You are currently viewing the Classic ASP Databases section of the Wrox Programmer to Programmer discussions. My Sql = "UPDATE Kontingent SET(Jan, Feb, Mar, Apr, Maj, Jun, Jul, Aug, Sep, Okt, Nov, Dec) = (2,2,1,1,1,1,1,2,2,2,2,2) WHERE Mem ID =18" I am updating another table before this one and it works fine, but when I excecute the statement. UPDATE Kontingent SET Jan = 2, Feb = 2, Mar = 1 WHERE Mem ID = 18 By the way - what database are you using, and are all of your fields of type INT?
This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. By joining today you can post your own programming questions, respond to other developers questions, and eliminate the ads that are displayed to guests. I have the need for updating multiple fields in a record.
Therefore, it should optimize the query so that it is only accessing the row in Table B once for each row in Table A.
Although you can apply the filters to the various fields by using several different techniques, the Filter by Form feature lets you define all your filters for the table at the same time and then see the results.
" It is also possible to UPDATE multiple columns at the same time. Cheers Karsten I shan't say they're wrong - but as previously mentioned - it's not a syntax that I reckognize.
Hi Jonax Thank for your reply I was afraid that this might be the problem, but others tell me that the following syntaks should be possible.