Jet sql update query

Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Asked 12 years, 8 months ago. Active 7 years, 10 months ago. Viewed k times. Improve this question. Juan Mellado Just think if it makes sense. I'm hoping that your database is normalized. Try it out, it takes care of any syntax requirements. Your comment is sounds like a joke.

Do you see a smiley behind it? I'm not in the habit of writing joke comments that span multiple lines. Add a comment. Active Oldest Votes. Improve this answer. Andomar Andomar k 44 44 gold badges silver badges bronze badges. Good luck! Bo Persson Does this work? Untested but should get the point across. Access saysL: "Operations must use an Updateable query.

See if that makes a difference. A google search says that "Operations must use an Updateable query. Only records that satisfy the expression are updated.

UPDATE is especially useful when you want to change many records or when the records that you want to change are in multiple tables. You can change several fields at the same time.

The following example increases the Order Amount values by 10 percent and the Freight values by 3 percent for shippers in the United Kingdom:. This example changes values in the ReportsTo field to 5 for all employee records that currently have ReportsTo values of 2.

Skip to main content. EventDay, T. EventDay, X. UniqueCustomerCount, Sub2. CustCount" below it like this:. Then Access tells me I must use an updateable query. In any case, can anyone get a single query with query and data all in Access to update the export table as explained? Failing that, is there a good theoretical reason why not? However, I am not sure that you actually need the tblExport. AFAIK, you can simply create the Select Query that return exactly what you need to export and then use the Query as the datasource for the export.

I agree with your second point that I would not need the tblExport except that what I show in the example is a small part of the table.

I start by deleting all of the records in the table and then appending new records, one for each day. Those appended records have most of the columns populated but there are a few columns that I update separately. I could make another query that would join the export table with the select query that gives me the event dates and customer counts and use that with TransferSpreadsheet.

However, again, this is a curiosity question and learning opportunity for me about the limits of update queries in JET and any tricks that would allow this type of update to work with a single query.