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!

Recent content by Magnolia1

  1. Magnolia1

    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.
  2. Magnolia1

    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...
  3. Magnolia1

    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] =...
  4. Magnolia1

    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...

Part and Inventory Search

Back
Top