I'm building a query: SELECT [EquipID], [UTIDNumber], [SerialNumber], [EquipDesc], [EquipCost], [CurrentLoc] FROM qryEquipmentInv WHERE OutOfInv = False and EquipTypeID <> 22 and EquipTypeID <> 23 and EquipTypeID <> 24 and CategoryID <> 2 and DeptOwned and Not(Not Isnull(ReturnedDate) and Issued) and [EquipCost] >= 500 ORDER BY [UTIDNumber];
I'm getting the error: Invalid Use of Null
I've actually taken out [EqiupCost] >= 500 and it works fine. This must be the problem. I'm not sure why I'm getting this error.