I have a form based on a union query that has the following fields
[inv $]
[curr]
[quote type]
the [curr] field has either CDN or USD results and i can SUM this field with the following expressions :
=Sum(-[inv $]*([curr]="CDN"))
=Sum(-[inv $]*([curr]="USD"))
the [quote type] field has many result groups but can be separated by :
=truck*
<>truck*
Is there a way i can add to my SUM expressions to show the CDN results for =TRUCK* and <> TRUCK* and the USD results for =TRUCK* and <>TRUCK*?
thanks in advance.