create field names using find & replace

[dvent]

Hi All,

I'm trying to take a table of masterdata and create a better version.

At the moment I have 2 milestones in my data for each milestone - a forecast and an actual date.

I am writing the following:

IIF(IsNull([Actual_Date]),[Forecast_Date],[Actual_Date])

However I have to do this for 100+ fields and its going to take ages manually.

Does anyone have a method of doing this quickly if I had a list of the Forecast -> Actual milestones in excel or word for example?

Thanks in advance
dvent

 

[namliam]

Yes excel is quite easy or just notepad search and replace...

Just go into SQL view (View > SQL View), copy the needed sql to what ever you want, alter it, copy it back, run it