conditional query

[Astrotek]

I have a variable condition query.
variable: X,Y,Z,A,B
XYZ can be confirmed by another table

If Y = MB

X+Y+Z=B

All Vairibles are on one table

If Y = DI

X+Y+Z=A

If Y = WH

X+Y+Z=A

A the number in the field is referanced in another table's
field

 

[Rick B]

I don't see a question anywhere in this post.