Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 416
  • Last Modified:

a iif function together with a sum function don't work in a form in access 2010

what it the problem with this method :
=IIf([Forms]![invoicef]![round]<>0,Sum([LineTotal]+[Forms]![InvoiceF]![round]),Sum([LineTotal]))
0
bill201
Asked:
bill201
1 Solution
 
Pratima PharandeCommented:
Sum([LineTotal]+[Forms]![InvoiceF]![round])

what you exactly expect fro this line
sum of both the sums ?

then try like this


Sum([LineTotal])+sum([Forms]![InvoiceF]![round])

In query

=IIf([Forms]![invoicef]![round]<>0,Sum([LineTotal])+sum([Forms]![InvoiceF]![round]),Sum([LineTotal]))
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now