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!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  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