I IanT Registered User. Local time Today, 08:49 Joined Nov 30, 2001 Messages 191 May 20, 2005 #1 Hi This is probaly really easy, I want to identify just minus figues in a query ie -5.00. I have tried iif([TotalPrice])<0,[TotalPrice]) this shows no result. Can any one advise. Thanks in advance.
Hi This is probaly really easy, I want to identify just minus figues in a query ie -5.00. I have tried iif([TotalPrice])<0,[TotalPrice]) this shows no result. Can any one advise. Thanks in advance.
Mile-O Back once again... Local time Today, 08:49 Joined Dec 10, 2002 Messages 11,305 May 20, 2005 #2 Just put <0 as the criteria.
