I have this query, shown below, in my Access code behind below that should return one record. But it is coming back as empty. Can anyone see what my problem is
StrSql = "SELECT tblOrders.*, tblFleetVendors.* FROM tblOrders INNER JOIN tblFleetVendors ON tblOrders.VendorId = tblFleetVendors.VendorID" StrSql = StrSql & " WHERE ((tblOrders.OrderingOrg)=" & Section & ") AND ((tblOrders.VendorId)<>774) AND ((tblOrders.OrderID)=" & Req & ");"