I have an aggregate query that totals fields in Table A, grouped by the primary key. The query has an expression (Expr 1) which sums a couple of the totals fields and works fine.
Table B uses the same primary key and has an integer field (AMOUNT)
I want a further field (Expr 2) to deduct Expr 1 from the integer field, viz:
Expr 2: [Table A]![AMOUNT]-Expr 1 - and choosing Expression in the Total field.
However it does not work, coming up with error: "Your query does not include the specified expression 'Expr 2: [Table A]![AMOUNT]-Expr 1' as part of an aggregate function.
Is there any way of getting this to work?