OK..I need to query a data form that is set to extract data from one table, but I have other fields on the same form that needs to extract data from another table. I have a query that I intend to use to reference the data I need...but my question is what is the syntax to make this happen. Here is what I have so far....
SELECT Door.AcctID, Door.HardwareSetID, Door.ProductID, Door.SillDetail, Door.Comments
FROM Door INNER JOIN Account ON Door.AcctID = Account.AcctID
WHERE ((([Form_Hardware Set - Main]! Software/Hardware used: Access 2007
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!