Kristen Jones
asked on
syntax while using the expression builder within a query
I have a report in Access 2007 that I am using a SUM function for a Field called Benefit. The report includes a field called EXEMPT where the value is either 1 or 0 I am trying to create a SUM total of all the BENEFIT numbers where the EXEMPT is <> 1
I know this is not right, but here is the logic:
=FormatCurrency(Sum([BENEF IT])) where EXEMPT <> 1
I know this is not right, but here is the logic:
=FormatCurrency(Sum([BENEF
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER