V Vu_Ho Registered User. Local time Today, 09:57 Joined Aug 19, 2013 Messages 20 Sep 18, 2013 #1 I want to put an expression that count all Debt in a field named "Payment". What would be an expression for this: =Count([Order].[Payment], "debt")? Thanks a bunch
I want to put an expression that count all Debt in a field named "Payment". What would be an expression for this: =Count([Order].[Payment], "debt")? Thanks a bunch
pbaldy Wino Moderator Staff member Local time Today, 09:57 Joined Aug 30, 2003 Messages 36,272 Sep 18, 2013 #2 In a form footer? Try =Sum(IIf(Payment = "Debt", 1, 0))
