railfan1975
New Member
- Joined
- Dec 7, 2005
- Messages
- 9
I am putting a query together using fields from two tables. In Table 1, I have Field A that I want to check against Fields C and D in Table 2. If Table 1.Field A = Table 2.Field C or Table 1.Field A = Table 2.Field D I want the value in Table2.Field E. If both matches fail, I want the query to return "XXXX".
What would be the best way to do this?
Thanks!
What would be the best way to do this?
Thanks!