Hello Friends;
I created a build in Query. The problem is, i need to define many things. For example :
Name: IIF([Table_name]![Field_name]="Dog";"Animal"; IIF([Table_name]![Field_name]="Cat";"Animal";IIF([Table_name]![Field_name]="Apple";"Fruit";IIF([Table_name]![Field_name]="Orange";"Fruit";IIF([Table_name]![Field_name]="Spinach";"Vegetable"; .......
it continues. At the end, there is no more place to define them. And min. i need to define 20 animals etc.
Is there a different way to do it ? Or simple way. I thought may be i can create new table and define there. but how can i use them in main table and query ? did not find a solution at this time.
I dont want to write any VBA code. Because i dont know anything about that.
Ty for your helps.
I created a build in Query. The problem is, i need to define many things. For example :
Name: IIF([Table_name]![Field_name]="Dog";"Animal"; IIF([Table_name]![Field_name]="Cat";"Animal";IIF([Table_name]![Field_name]="Apple";"Fruit";IIF([Table_name]![Field_name]="Orange";"Fruit";IIF([Table_name]![Field_name]="Spinach";"Vegetable"; .......
it continues. At the end, there is no more place to define them. And min. i need to define 20 animals etc.
Is there a different way to do it ? Or simple way. I thought may be i can create new table and define there. but how can i use them in main table and query ? did not find a solution at this time.
I dont want to write any VBA code. Because i dont know anything about that.
Ty for your helps.