Robert Schumann
asked on
Report Textbox Expression error
HI
Where am I going wrong with this expression. It's returning all Invoice values. If I drop the last part And "[id]=19 it returns the correct value.
=Nz(DSum("Invoice","Purcha seOrders", "[ordertyp e]='opex'" And "[id]=19"),0)
Thanks
Where am I going wrong with this expression. It's returning all Invoice values. If I drop the last part And "[id]=19 it returns the correct value.
=Nz(DSum("Invoice","Purcha
Thanks
ASKER
Great, it's working. Thanks
Now, I need to add another criteria. Tried this, but it returns "$0.00" Thought I could just add an addition "AND".
=Nz(DSum("Invoice","Purcha seOrders", "[ordertyp e]='opex' And [id]=19 And [id]=17"),0)
Now, I need to add another criteria. Tried this, but it returns "$0.00" Thought I could just add an addition "AND".
=Nz(DSum("Invoice","Purcha
Id cannot be both 17 and 19.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you all. Great help!!
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you both. They were both great answers!!
Open in new window