Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Help with update query
Hello Andy, Thank you for your reply. I found the way how to correct my issue and make it work. Thanks again.- Magnolia1
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Help with update query
Hello Everyone, I've built a simple select query that filters the data on a certain criteria: SQL code is listed below: SELECT ContractsDataSet.[Company Name], ContractsDataSet.StreetAddress1, ContractsDataSet.Contact, ContractsDataSet.CompanyID FROM ContractsDataSet WHERE...- Magnolia1
- Thread
- Replies: 3
- Forum: Microsoft: Access Queries and JET SQL
-
Hello, I need help with my query. I
Hello MajP, Thank you for your response. The SQL for my query is as follows: SELECT Table2.[Account Number], Table1.[Sub Account Number], Table1.[Account Name], Table1.Amount FROM Table1 LEFT JOIN Table2 ON (Table1.[Sub Account Number] = Table2.[Sub account number]) AND (Table1.[Account Name] =...- Magnolia1
- Post #3
- Forum: Microsoft: Access Tables and Relationships
-
Hello, I need help with my query. I
Hello, I need help with my query. I built 2 tables: Table 1: sub account number, account name, amount paid (Record one: abc, Tree, 100; Record two: abc, Tree, 200) and Table 2: account number, sub account number, account name (Record one: 1122, abc, Tree; Record Two: 3344, acb, Tree). I joined...- Magnolia1
- Thread
- Replies: 2
- Forum: Microsoft: Access Tables and Relationships
