Do a compound join on Brand and Item fields.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Hi,
Thanks so much for your reply.
My access skill is very limited, could you do me a favor giving example script to do compound join ?
Jonathan
Use the query builder and grab and drag a link line from one table to another on both pairs of fields. Very simple. Then switch to SQLView to see the SQL statement.
If you build these links in Relationship builder, they will automatically appear in query.
https://www.opengatesw.net/ms-access...cess-Query.htm
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.