update script for Access 2007 - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Other Forums

MS Access

update script for Access 2007

Author

Topic

ams006
Yak Posting Veteran

55 Posts

Posted - 2009-06-01 : 07:04:42

Hi all,

I have a table in which I need to update lots of records which have a particular field in common.
Can anyone give me the access syntax needed to do a simple update script to perform something like this:

update {tablenmae}
if tablename.fieldname = 'M1' then tablename.Qualifying(fieldname to update) = '1'

Thanks

ams006

ams006
Yak Posting Veteran

55 Posts

Posted - 2009-06-01 : 10:02:10

Not to worry, I've sorted it!!......

Sequin
Starting Member

25 Posts

Posted - 2009-06-03 : 10:29:02

UPDATE tablename
SET tablename.[Qualifying fieldname to update] = "1"
WHERE tablename.fieldname = "M1"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources