Creating Query

  • Thread starter mustish1 via AccessMonster.com
  • Start date
M

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
 
J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top