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?
correlateAsked:
Who is Participating?
 
peter57rCommented:
The query would just be..

Update Newsletter set Uploaded = True where [story type] <>"The ending" and Uploaded =false

'Efficiency'  would be a case of indexing the [Story Type] field (but NOT the Uploaded field)

I am assuming that Story type cannot change from 'The ending' to something else and that Uploaded must be either True or False.
0
 
ukerandiCommented:
You can use below code

Go to MS Access Design View - > SQL View
Paste below code


UPDATE Newsletter SET Uploaded=“Y” where [Story Type] <>"The Ending"

Open in new window

0
 
ukerandiCommented:
code syntax
Syntax 

UPDATE [Tablename] SET Fieldname=“Y” where [Fieldname] criteria

then should be

UPDATE Newsletter SET Uploaded=“Y” where [Story Type] <>"The Ending"

Open in new window

0
 
correlateAuthor Commented:
brilliant - thank you for that
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.