computing a rounded number

[sheederj]

I have a computation in a query which results in numbers with extensive decimal places. I need to match the calculated values to a lookup table where the matching value only has two decimal places. Because of this difference, they don't match. I tried making a new table from the query and setting the fixed value to two decimal places, but it doesnt work. access still thinks they have however many decimal places. Any ideas on how to make this work?
thanks for your help!

 

[pbaldy]

How about the Round() function?

Round(YourCalculation,2)

 

[sheederj]

that worked great! thanks very much!