Creating Query

[mustish1 via AccessMonster.com]

Hi:
Can any one please tell me how to i write a query if TableB field MatchField
contains value FieldB then FieldB join with FieldD of TableD and FieldS match
with FieldSS. If MatchField contains value FieldC then FieldC join with
FieldD of TableD and FieldS match with FieldSS. If MatchField contains value
of FieldK then FieldK join with FieldD of TableD and FieldS match with
FieldSS. If FieldS is not match with FieldSS but other fields of TableB
FieldB, FieldC, FieldK match with FieldD of TableD it still print the result.

TableB
----------
KeyField
FieldB
FieldC
FieldK
FieldS
MatchField

TableD

 

[Jeff Boyce]

I'm not sure I'm understanding...

Are you saying that you wish to join different fields, depending on the
value in one table? Could you provide a bit of "real world" data?

Regards

Jeff Boyce
Microsoft Office/Access MVP