How do i create a new field in a query

[jayjayuk]

im following a practice lesson. and i have created a query from a table. and now its asking me to create a new field in the query called REFUND and calculate the refund due by multiplying paid by 12.5% (0.125) but i have tried in design view and datasheet view but i just cant seem to work out how to do it. can anyone help ?

[NoellaG]

Hi,

just create a calculated field in the query by example window by typing the following as field name (make sure PAID is a known field name):

REFUND:PAID * 0.125