Select Replace in MS Access Queries

Question posted by: maryanncanor (Newbie) on July 25th, 2008 09:47 AM

Hi,

I have 3 tables. Table1, Table 2 and Table3.

How Can I update(only one time) Table 2 using the Mapping Table3 ?



Table 1 have the ff fields:
_______________________________
Transaction | ProductType | Product |
-----------------------------------------------------
001 | | X
002 | | Y


Table 2 have the ff fields:
_______________________________
Transaction | ProductType | Product |
-----------------------------------------------------
| | | |
| | | |


Mapping Table 3 have the fields:
___________________________________
| Productype1 | Productype2
-----------------------------------------------------------
11111111 | 22222222


Conditions:

If the Product field of Table 1 is equal to “X”:
Get Productype1 in Table 3 and Place it in ProductType field in Table2

If the Product is equal to “Y”:
Get Productype2 in Table 3 and Place it in ProductType field in Table 2


Here is my Query:

UPDATE Table2 SET Table2.Product = "1111111"
WHERE ((([Table1].Product)="X"));

I think this is incomplete, because, this is only applicable to 1 condition which is If Product is X, What if Product isequal to Y, Does it mean Another query should be made?

How Can I update(only one time) Table 2 using the Mapping Table3 ?

Is Select Replace applicable?

Thank you for taking time to help me.

Not the answer you were looking for? Post your question . . .
189,759 Experts ready to help you find a solution.
Sign up for a free account, or Login (if you're already a member).