I have a table in which I need to create categories from values in a column. For example, a column/field A has the following possible entries:
broccoli, spinach, beans, peas, cauliflower
orange, apple, pineapple, mangoes, cherries
fish, chicken, beef
I would like to create an if/in/then statement in a query to indicate that the first group above is "vegetable" the second group above is "fruit" and the third group is "meat."
Please advise on an efficient formatting for this. "Vegetable" "Fruit" "Meat will all be in a newly created column B called "Food Type" based on the values of Column A.