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 TouchToneTommy 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: *

  • Users: lovallee
  • Content: Threads
  • Order by date
  1. lovallee

    VBA - feed Excel pivot table from DAO recordset

    Hello, I have the code below that is used to feed a pivot table cache with a DAO recordset. The code was from a similar macro used with ADO. However the code fails at: Set Workbooks(ActWbk).Worksheets(ActSht).Range("MainPivot").PivotTable.PivotCache.Recordset = DAOrs Error is: Run-time...
  2. lovallee

    SQL LEFT JOIN to return only first matching instance

    Hello, I have been searching for a way to get my expected results but with no luck so far. Question: my LEFT JOIN operation can result more than one match but I only want the query to return the first matching instance (see sample below). Is that possible? Table1 Field1 Field2 A D B D C...

Part and Inventory Search

Back
Top