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

    Summing in Self Join

    Here is the SQL for question above, if this will help. SELECT tblItemMaster.PartNmbr, tblItemMaster.ItemClass, "1" AS [Level 1], tblBOM.ChildClass, tblBOM.ChildPartNmbr, tblBOM.QtyReq, "2" AS [Level 2], tblBOM_2.ChildClass, tblBOM_2.ChildPartNmbr, tblBOM_2.QtyReq, "3" AS [Level 3]...
  2. LostSon

    Summing in Self Join

    I have a self join query that creates a bill of material for 6 levels deep. The fields are: PartNmbr Item Class Level ChildPartNmbr QtyReq The above fields repeat 5 times. I want to sum the "QtyReq" for each parent part number ("PartNmbr") where "Item Class = 43" for each "ChildPartNmbr" on...
  3. LostSon

    Error '3024' File not found

    Guess I'll have to for now. It just drives me nuts when I know something should work and I can't figure out why it isn't. Thanks!
  4. LostSon

    Error '3024' File not found

    Same error. Do I need to do anything before executing the SQL string? Open the external DB, or something?
  5. LostSon

    Error '3024' File not found

    Hello, I get error '3024', Could not find file 'G:\...' when I try both of these pieces of code. I have checked the spelling and the file is there. Please help. #1 Public Sub LoadTables() Dim strSQL As String Dim dbAAPCost As Database Set dbAAPCost = CurrentDb strSQL = "INSERT INTO tblBOM...

Part and Inventory Search

Back
Top