Total of a Calculated Field in Access Query - Microsoft Community

hi all,

i'm newer access, might simple answer: i'm trying build query includes calculated field: ([price of item] * [1 + tax%]). [price of item] is currency data type, and [tax%] is  a number. runs it's supposed in query, when try , add totals row query, it gives me options "none" or "count" particular field if try format currency. if don't try format currency, however, option sum there, have in currency format. why not able sum it, i'm able [price of item] field (or other fields) in currency format?

thank in advance.

p.s. i'm running access 2013.

however, i'm still little uncertain of why the total button in query not give me option sum.

i'm pretty sure it’s fact formatting value limits available aggregation operations.  formatted value string expression, cannot summed.  if interface data via form or report, on other hand, can sum expression without formatting, , apply format result.

Office / Access / Windows 10 / Office 2013