update help conditional query

[AstroTek]

the variable condition are:
bpentid= x
bproleid=y
prodbrnd=z
parentbilling=a
billing=b
X,y,z and b are on the same table
A is on the another table
each table has a primary code generated by access
If y=mb
x+y+z=b or x and b
if y=wh
x+y+z=a
if y=DI
x+y+z=a

A has to be looked up on a table to find b
each field
x is an eight digit number
y is a two digit alpha
z is a two digit alpha
b is an eight digit number
A is an eight digit number
I am trying to put the conditions into one two or three queries

 

[HitechUser]

Your multiple posts are confusing.

Post1
and
Post2
and
Post3

Please, Please, Please, post only to one message so that we may follow your progress or questions.

 

[AstroTek]

you may understand how I feel about this assignment