Choosing what table to update base on column value

[guillermoftw]

Hello All,

I'm running into a little bit of a runt. Based off 1 of 2 values in column will decide what table will be opened and updated. Updating is the easy part I'm just not sure how to basically write an IF statement in SQL.



Any help would be appreciated.

Thanks!

[pbaldy]

The question implies a normalization problem (why multiple tables?), but you won't be able to do this directly in a query. You would have to use code to either build a query or choose one.

[guillermoftw]

I have info stored in two different tables that need to be separated but depending on the value that is in the excel sheet imported will decide what table is updated. I am attempting to build a vba function to run SQL depending on a columns value. We'll see how this works out.

[darshit_goswami]

as pbaldy said it should be normalization issue. but still if u want to do it anyhow ,.. u can build a dynamic query and achieve the results. If then would be a choice or in better ways select case can do the job. I dont know what u want to achieve exactly but hope this helps.

[June7]

Access query object cannot be dynamic for the table. Maybe in SQL or Oracle database, but not in Access.