It would require many Iifs on the query. Why dont you call a function instead. Out in a module:
Public function fnStatus(f1 as variant, f2 as variant, f3 as variant) as string
Dim r1 as byte, r2 as byte, r3 as byte, r as byte
If not isnull(f1) then
r1=1
End if
If not isnull(f2) then
r2=1
End if
If not isnull(f3) then
r3=1
End if
r=r1+r2+r3+1
fnStatus=choose(r, "pending-pending-pending","pending-pending-ok","pending-ok-ok", "ok-ok-ok")
End function
On your query:
DOX STATUS: fnStatus([IP Request Receive Date], [Authority Letter Receive Date], [Duty Exemption Letter Receive Date])