Rounding an expression?

[click]

I am baffled. I have two tables, among other fields, one has units(integers) and the other one has prices. My query expression is:
Expr1: [PF008]![Price]*[partfund]![N8]

This creates another table, with supposedly the result of this multiplication, except that the new field looks something like this:

237464.88892399
423324234.67538429

Why would it be multiplying like that? Is there something I have to do to the new table to stay at only two decimals? Also, why if I change the table, it gets "creamed" every time the query is run? wouldn't just the contents of the table change, instead of creating the table from scratch?
Thanks. Click

 

[crose7227]

You can set the Format property of that field to Standard.

you need to make an append query to add new items to the table. Otherwise it WILL write over the data that is there. land of milk and Honey