New
#1
access 365 SUM in table
Source Table has several occurrences (rows) of CC CHASE JH, but QRY coding below only gives me SUM last row entry.
Example:
Source table row 1 has value of 750.00
Source table row 22 has value of 2,500.00
QRY result displays 2,500.00
Any help is greatly appreciated.
Chase: Sum((IIf(Left([Company],11)="CC Chase JH ",[AMOUNT])))