Multiple If statements

[orchid67]

I have a table that I need to use multiple if statements to update the description of a field and then create a new column for these results
Table: MyPlants

if field1= "Flowering Plants" then
field1= "Garden 1"
if field2= "Herbs" then
field2- "Garden 2"

I have multiple ifs like 30

Then I have a create another column for the results like

New Column (Updated List) in MyPlants Table

Updated List
Garden 1
Garden 2

[PhilOfWalton]

It sounds as if your database is not normalised.

Could you please let us have your MyPlants table structure and some sample data and where you want this Updated List to appear.

Phil

[NeoPa]

This approach doesn't sound very well thought out, or maybe it's just poorly explained.

Anyway, overwriting your original data is very rarely a good approach. Without more information (Even if your question is accurate it's very sparse on logic so we're working blind to a large extent.) it's hard to know for sure, but I'd consider a table structure that allows for data transformation (probably not in place) based on some form of lookup table.

[NeoPa]

In this case it looks like some form of lookup is required. Thirty-odd Ifs is very cumbersome indeed. Not a fun way to write code.

For handling such things in VBA (Which I don't recommend but I'm covering anyway for info.) you could consider the Select Case construct or the Switch() function if you need a single returned value based on many different checks.

[PhilOfWalton]

Am waiting for more info, but it's my guess that he needs a a table of Plants, a table of Locations and probably a joinPlantLocation table

Phil

[NeoPa]

Indeed. It's hard to offer advice when the question hasn't been formulated properly. So much guesswork, and one thing wrong can make all the advice inappropriate :-(