Hi,
Trying to SUM all records where first 3 characters of Company = DMV. Have tried all kinds of () but always get the Enter Parameter... prompt.
What am I missing on query?
DMV: Sum((IIf([left$(Company,3)]="DMV",[AMOUNT],Null)))
Your help is greatly appreciated.
A Healthy and Happy 2016...