"If then" statements

[MD2821]

Question:

Correct ways to update approximately 5 columns of data with a proper "if then" statement. (ie: if you are located at such an such hospital, then you're a hospitalist)

 

[traingamer]

More information, please. Is all of your data found in tables (and thus could use queries)? Do you need to prompt for answers? (There will probably be more than one correct answer).

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill

 

[MD2821]

yes, all my data is coming from tables. Also, this is not an interactive so it does not need to prompt for answers. I am thinking that I might be able to get it to update to the correct classification by using a simple expression builder and typing in exactly I would like the columns to update to if they have a certain current classification. Can I ask you when would be a proper time to use an if then statement? When do you find them occurring the most??

Thanks.