ODBC --call failed. (1 Viewer)

SELECT 
	dbo_neigh_control.neigh_name
      , dbo_parcel_base.district_number
      , dbo_parcel_base.property_class
      , dbo_parcel_base.parcel_id
      , dbo_land_detail.soil_id
      , dbo_parcel_base.legal_acreage
      , dbo_land_types.land_type_desc
      , dbo_land_methods.method_desc
      , dbo_land_detail.true_tax_value1
FROM (((dbo_land_detail 
      INNER JOIN dbo_parcel_base ON dbo_land_detail.lrsn = dbo_parcel_base.lrsn) 
      INNER JOIN dbo_land_types ON dbo_land_detail.land_type = dbo_land_types.land_type) 
      INNER JOIN dbo_neigh_control ON dbo_parcel_base.neighborhood = dbo_neigh_control.neighborhood) 
      INNER JOIN dbo_land_methods ON dbo_land_detail.lcm = dbo_land_methods.method_number
WHERE (((dbo_parcel_base.status)="A") 
      AND ((dbo_land_detail.status)="A") 
      AND (([neigh_name] Like "*" & [Forms]![FLandDetailSearch]![cboHood] & "*" 
		                 Or [Forms]![FLandDetailSearch]![cboHood] Is Null)=True) 

      AND (([method_desc] Like "*" & [Forms]![FLandDetailSearch]![cboMethod] & "*" 
		                  Or [Forms]![FLandDetailSearch]![cboMethod] Is Null)=True)
 
      AND (([property_class]=[Forms]![FLandDetailSearch]![cboPropClass] 
		          Or [Forms]![FLandDetailSearch]![cboPropClass] Is Null)=True) 

      AND ((dbo_parcel_base.district_number)=[Forms]![FLandDetailSearch]![cboArea] 
					     Or [Forms]![FLandDetailSearch]![cboArea] Is Null)=True) 

      AND (([soil_id] Like "*" & [Forms]![FLandDetailSearch]![cboSoilClass] & "*"         
		              Or [Forms]![FLandDetailSearch]![cboSoilClass] Is Null)=True) 

      AND (([land_type_desc] Like "*" & [Forms]![FLanddetailsearch]![cboLandType] & "*" 
		                     Or [Forms]![FLandDetailSearch]![cboLandType] Is Null)=True) 

      AND ((dbo_neigh_control.district_number)=[Forms]![FLandDetailSearch]![cboArea] 
		                               Or [Forms]![FLandDetailSearch]![cboArea] Is Null)=True));

SELECT code, acct nbr, date, user, sum(amt)
FROM Tbl a
group by code,acc nbr,date,user
HAVING code IN
('AB',
'BC',
'CD',
'AA',
'BB',
'CC',
'ZZ'
)
AND date BETWEEN TO_DATE ('20070101', 'YYYYMMDD')
AND TO_DATE ('20070131', 'YYYYMMDD')

tblTransaction
--------------
PartID
TransType
TransQty

PartID  TransType  TransQty
---------------------------
1111-2  I          12
2244-3  I          23
1111-2  I          17
2244-3  O          5
1111-2  O          11
2244-3  O          13

SELECT PartID, Sum(TransQty) AS TotalQty
FROM tblTransaction
WHERE TransType = 'O'
GROUP BY PartID
HAVING PartID = '2244-3';