adding field

[Tech]

hi there.

in a query, how can I add a "non existant" field, where it can do a calc, for example, the sum of all prices or something like that.

i have like a total price/order value and need to calculate commision, of lets say 10%.

what do I put in a field in the query design view?

 

[KevinM]

Create an expression in a query...

Commission:[MyPrice]*0.1

 

[Tech]

ok cool, what about, telling that field to display it in currency and rounded to 2 dec places?

 

[Mile-O]

Right click on your new calculated field in design and select properties from the popup menu.

You can change the format here.