Avatar of Tom Crowfoot
Tom Crowfoot
Flag for United Kingdom of Great Britain and Northern Ireland

asked on 

Update Table

Dear Experts

I need to find the most efficient way of updating records on mass.  What I am trying to achieve is to update records in a table that meet a certain criteria. The table is linked to a sharepoint 2010 list (but this shouldn't make any difference (I hope))

The fields involved are as follows:

Table = “Newsletter”

Field to update =  “Uploaded” (a Yes/No field)

Criteria Field = “Story Type” (Text) - where <> “The Ending”

So the statement would be to mark “Uploaded” as Yes except if Story Type = “The Ending”

The table will grow on average by 2,000 records a year, but each time this code is run there is likely to only be 30-40 records that need updating.

Can anybody help?
Microsoft Access

Avatar of undefined
Last Comment
Tom Crowfoot

8/22/2022 - Mon