Access Help has guidelines on creating queries.

Cannot have an expression like that in a table Calculated field (introduced with Access 2010). Table Calculated field is for expressions like: [Quantity] * [Price].



That expression multiplies the two fields to present an extended price. Functions don't work in the field. Use a query to do manipulation of data with functions.