update query to update calculated fields

[emcf]

Morning all,

after a quick search I could not find a posting that could help me. Problem is that I have numerous queries of which about half use calculated fields that need to be amended (CEO changed how he wants certain info calculated).
The two main changes I need are -

CurrentNumber: [CurrentProbability]+[CurrentImpact]

need to change the + to a *

and -

CurrentBand: IIf([CurrentNumber]<=5,"Green",IIf([CurrentNumber]>=7,"Red","Yellow"))

I need to change the 5 to a 4 and the 7 to a 10.


Is there a way to do this with an update query without trawling thru every query and changing it manually???

thanks in advance,

 

[Rich]

Rick Fisher's find and replace tool is recommended here often, you'll have to search for the link though.