SQL query acting differently in Access and from ADO.

SELECT WorkOrderNo AS OrderNo, Sum(TotalCost) AS BookedCost
FROM WorkOrderLineItems
WHERE (ItemID Not In ('96ssssss','96SSSSSS','97mmmmmm','97MMMMMM','9606  0033','96049001','96060025','96049000')) And Deleted=False And Status<>'F'
GROUP BY WorkOrderNo;

SELECT WorkOrderLineItems.WorkOrderNo AS OrderNo, Sum(WorkOrderLineItems.TotalCost) AS FutureCost
FROM WorkOrderLineItems
WHERE (((WorkOrderLineItems.ItemID) Not In ('96ssssss','96SSSSSS','97mmmmmm','97MMMMMM','9606  0033','96049001','96060025','96049000')) AND ((WorkOrderLineItems.Deleted)=False) AND ((WorkOrderLineItems.Status)='F'))
GROUP BY WorkOrderLineItems.WorkOrderNo;

SELECT WorkOrderNo AS OrderNo, Sum(TotalCost) AS LaborCost
FROM WorkOrderLineItems
WHERE Deleted=False And ItemID In ('96060033','96049001','96060025','96049000')
GROUP BY WorkOrderNo;

SELECT WorkOrderLineItems.WorkOrderNo AS OrderNo, IIf(Sum(UnitResale)=0,Sum(WorkOrderLineItems.Total  Cost),Sum(WorkOrderLineItems.TotalResale)) AS SalesQuote
FROM WorkOrderLineItems
WHERE (((WorkOrderLineItems.Deleted)=False) AND ((WorkOrderLineItems.ItemID) Like '9?mmmmmm'))
GROUP BY WorkOrderLineItems.WorkOrderNo;

SELECT WorkOrders.OrderNo, IIf(IsNull([LaborCost]),0,[LaborCost]) AS LaborC, IIf(IsNull([BookedCost]),0,[BookedCost]) AS BookedC, IIf(IsNull([FutureCost]),0,[FutureCost]) AS FutureC, [BookedC]+[FutureC] AS MaterialCost, [LaborC]+[MaterialCost] AS TotalCost, ResaleByOrderNo.SalesQuote AS SalesQ, [SalesQ]-[TotalCost] AS Profit, WorkOrders.Active
FROM (((WorkOrders LEFT JOIN BookedByOrderNo ON WorkOrders.OrderNo = BookedByOrderNo.OrderNo) LEFT JOIN FutureByOrderNo ON WorkOrders.OrderNo = FutureByOrderNo.OrderNo) LEFT JOIN LaborByOrderNo ON WorkOrders.OrderNo = LaborByOrderNo.OrderNo) LEFT JOIN ResaleByOrderNo ON WorkOrders.OrderNo = ResaleByOrderNo.OrderNo
WHERE (((WorkOrders.Active)=True));

<script runat="server">

    Sub Page_Load
         dim dbconn,sql,dbcomm,dbread
         dbconn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;data source=" & server.mappath("/DB/Business.mdb"))
         dbconn.Open()

         SQL = "SELECT * FROM WORecap WHERE Active = TRUE"
         dbcomm = New OleDbCommand(SQL, dbconn)
         dbread = dbcomm.ExecuteReader()
         OpenWORecapTable.DataSource=dbread
         OpenWOrecapTable.DataBind()

         dbread.Close()
         dbConn.Close()
     End Sub

</script>