Order By "Invalid use of Null"

[greatwhite]

I have this query in MS Access and when I add an order by I receive the error "Invalid use of Null" it works fine if I exclude the Order by. Any suggestions

SELECT tblEquip.keyEquip, tblEquip.keyShip, tblEquip.strFPN, tblEquip.keyCmpt, tblEquip.strLoc, tblEquip.strID, tblEquip.strEquipType, tblEquip.strDescription, tblEquip.strNotes, strOldValue, strNewValue
, tblAuditTrail.strChangeType, tblAuditTrail.strTableName, tblAuditTrail.numRecordID
FROM tblEquip INNER JOIN tblAuditTrail ON (tblEquip.keyEquip =CLng(tblAuditTrail.strOldValue))
where strfieldName = 'keyEquipDn'

order by strOldValue

[RuralGuy]

Have you tried using Nz(strOldValue)

[greatwhite]

Yes just tried it now and same response also tried CLng. There are no Nulls

[RuralGuy]

Have you done a Compact and Repair lately?

[greatwhite]

Yes, I'm thinking it is a limitation in MS Access pretty sure I can do this in SQL Server.

[RuralGuy]

I would still try *importing* your db into a fresh new db before giving up. It only take a minute and would leave any possible corruption behind.