Just to provide an update on this one: what I ended up doing was using the Val function on the result, e.g. Round(Val([TOTAL]),2). Banker's rounding now seems to work as expected - incredible!
My thanks again to all who kindly took time to offer their suggestions.