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!

Recent content by LostSon

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

Part and Inventory Search

Back
Top