Help on quick Replace calc!

[LaRetta]

I need to run REPLACE through a set of newly imported records

Field GL# needs to be set according to another field PGM

If PGM="Out Patient" set GL# 4000

If PGM="STDT" set GL 4010

etc.

Can someone help me? I think I need Case?

[andygaunt]

In your replace by calculated result.

Case ( PGM = "Out Patient", 4000,

PGM = "STDT", 4010

)

HTH

[LaRetta]

That did it! I had to add a few more GL#'s ... My old background would have used If( I don't really understand Case yet but I figured it would be Case. Bless you, Andy!

[Fitch]

Case is just like If, except the default value is optional, and also you can run multiple tests without complex nesting. So I almost never use If anymore.

[LaRetta]

Hey, thanks for clarifying that ... I've got an If/Else attitude and had never used Case before discovering FM. All I know is that, all the posts say to use Case instead of If, and I trust there's a good reason ... now it's makes sense why! I appreciate your input!