Home > IT Answers > Microsoft Windows > Query that uses input data from another form
DaChosenOne
5 pts.
 Query that uses input data from another form
Access 2007, Access query, Access Tables, Data Extraction, Query Parameters
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
ASKED: August 15, 2010  4:42 AM
UPDATED: August 16, 2010  2:13 PM
RELATED QUESTIONS
Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _