Update Query?

A

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
 
A

Al

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

Al
 
D

Duncan Bachen

Al said:
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
Click to expand...

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.
 
Top