Sorry Pat, I'd have to disagree here, despite being a novice.
You probably write your SQL yourself, but if you use the design grid and then use totals, Access creates that alias. I can tell as I have had that in the past and recognised the format?. That is why I mentioned in post 11 that (really Access) had named the field as that.?
So that was the default name that Access gave to the calcualted field.?
SELECT tblTransferFee.TWMPaid, Sum(tblTransferFee.AppliedAmount) AS SumOfAppliedAmount
GROUP BY tblTransferFee.TWMPaid;
Originally Posted by Pat Hartman
You're welcome but it is important to understand what happened.
Access didn't do this, you did!!!
Is an alias. However, If you hadn't given the calculated value a specific name, Access would have given it a default name. EVERY column MUST have a unique name even a calculated one. Otherwise, how would you refer to it?