Okay SQL experts:
I'm getting an error message that a parameter is expected, but don't know where it is wanting it.
Here's the code:
strsql = "SELECT bePCPlanIndBOM.[$$RRLV] AS [Level], bePCPlanIndBOM.[$$ITEM] AS Component, " & _
"bePCPlanIndBOM.[$$DESC] AS Description, bePCPlanIndBOM.[$$UOM] AS UM, bePCPlanIndBOM.[$$STKT] AS Type, " & _
"bePCPlanIndBOM.[$$QTY1] AS [Required Per], " & _
Forms![CSQuotes]![Qty] & " AS Requested, [Required Per]*[Requested] AS Extended, " & _
"ItemQtyOH.JDEQty AS [On hand], [On hand]-[Extended] AS Available" & _
" FROM (GetProgSSForParent INNER JOIN bePCPlanIndBOM ON (GetProgSSForParent.TimeStamp = bePCPlanIndBOM.TimeStamp)" & _
" AND (GetProgSSForParent.ProgSS = bePCPlanIndBOM.ProgSS))" & _
" INNER JOIN ItemQtyOH ON bePCPlanIndBOM.[$$ITEM] = ItemQtyOH.ItemNum;"
Currentdb.execute(strsql)
I've accounted for the form field it is pulling in, but am wondering if the calculated fields are tripping me up.
Liz Ravenwood
Database Developer / Programmer
Super First Class Products
B/E Aerospace
O: 1.520.239.4808
www.beaerospace.com
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
Tidak ada komentar:
Posting Komentar