the variable condition(s) 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 billing number
each field
x is an eight digit number
y is a two digit alpha
z is a two digit alpha
I am trying to put the conditions into one two or three queries.
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 billing number
each field
x is an eight digit number
y is a two digit alpha
z is a two digit alpha
I am trying to put the conditions into one two or three queries.
