Update Query?

[Al]

I have a simple example. A simple single table db. My table has 20 or
so fields. I want to modify the Sub_Account field based on a condition
in the Account
field. Something like:
If Account = 5005 then set Sub_Accout = 0005
How do I do that?

Thanks,
Al

 

[Lynn Trapp]

Update YourTable
Set Sub_Account = 0005
Where Account = 5005;

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[Al]

Thanks Lynn - Do I place that right in Update To: and Criteria:?
I'm getting invalid syntax in Criteria => Where is highlighted.

Al

 

[Lynn Trapp]

No,
You put the value you want to change the field to in the Update To: box. You
then put just the value of the Account in the Criteria field. Don't put the
word Where in there.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[Duncan Bachen]

I have a simple example. A simple single table db. My table has 20 or
so fields. I want to modify the Sub_Account field based on a condition
in the Account
field. Something like:
If Account = 5005 then set Sub_Accout = 0005
How do I do that?

Thanks,
Al

Psst. You already started a thread in m.p.a.gettingstarted to which I
have already replied. Starting multiple threads in multiple newsgroups
is considered bad etiquette.