Need Help to get automatic text for particular selection

[Naveed Raza]

Hi All,I Need small help in Access Table.I Pull small data from excel to access and in Table "Sub Activity" Field is thr if in this filed "Exception","Random Fee" and "Missing Fee" is thr then in Last Field automatic "Exception" should come and if "Correction" is thr then "Correction" shd come like this if "Plant Check" and "Plats" then "Plats" shd come.as i very new to access and i unable resolve this and i am sure anyone help me out from this situation. Thanks in Advance !Thanks - Naveed.

[orange]

Please provide more info. What exactly are you trying to do? What is your database about?
What exactly is the issue/problem you are having?
Please provide an example to show what is happening to what, and what you want to happen.

We can not help you unless we understand your issue/problem.

[June7]

Cannot do calculations in Access 2007 tables. Calculate data in queries or on forms or reports.

If you want to save the calculated results to table, will require code. Usually not a good idea to save calculated results. Calculate data when needed.

Expression could be:

IIf([Sub Activity]="Correction", "Correction", IIf([Sub Activity]="Plats", "Plats", "Exception"))

If you put the expression in a textbox ControlSource property, be sure to prefix with = sign.

Search Access Help or Google for guidance on constructing expressions.