Field Updating Field 1

[Greg25]

Hi
I am working with SQL 7 & Access 2000
I am not a programmer

Trying to have field 1 (last cost center) update to “14”
When field 2 (Billed job) = 1
This is all on the table order_entry

It sounds as if it could be done using a trigger or/an if ?
But just don’t know how to write the info or what to do with it

I wish there could be something I could help you people with

I mostly know graphic applications and files Quark, Ill, Photoshop, Freehand ect.

Thanks again Greg

 

[rajeevnandanmishra]

Hi there,
Try to execute following
--------------------
UPDATE order_entry
SET last_cost_center = 14
WHERE billed_job = 1

--------------------

Hope it helps!