Recent content by Topflite66

Thank you for your responses. I appreciate the comments. I was able to get a solution from a user on another Access site which works perfect. CountIncoming: Count(IIf([tbl_OrderDetails]![VIN] Is Null Or [tbl_OrderDetails]![OnLot]=True Or Not [tbl_OrderDetails]![DateSold] Is Null, Null,1))...

I am working on a nested Iif statement that counts vehicles that need to meet 3 separate criteria. Below is my Expression in a query: CountIncoming: Count(IIf([tbl_OrderDetails]![VIN]=Null,Null,IIf([tbl_OrderDetails]![OnLot]=Yes,Null,IIf([tbl_OrderDetails]![DateSold] Is Not Null, Null,1))))...