I am using Access 2000 on XP. I am using three tables for this query:
Expand|Select|Wrap|Line Numbers
- BANKS
- BankID (pk)
- BankName
- Other fields that are not pertinent to this query
Expand|Select|Wrap|Line Numbers
- VENDORS
- VendorID (pk)
- VendorName
- Other fields that are not pertinent to this query
Expand|Select|Wrap|Line Numbers
- BANKVENDORS
- BankID
- VendorID (both fields combined make up the pk)
Here is what I have so far in the query (I used the Wizard to create it):
Expand|Select|Wrap|Line Numbers
- SELECT Banks.BankName, Vendors.VendorName
- FROM Vendors INNER JOIN (Banks INNER JOIN BankVendors ON Banks.BankID = BankVendors.BankID) ON Vendors.VendorID = BankVendors.VendorID
- WHERE (((Vendors.VendorName)=[Enter Vendor Name]));
-Carolyn