Rounding to 2 decimal places

[elna_kay]

I have a database that has raw data input to 2 decimal places. There are multiple queries set up to sum the total cost by facility and box type. When the queries are run, the output is to 4 decimal places. I need to round the cost to 2 decimal places. (Right now, it is formatted to show 2 decimal places, but when you click on the number, there can be up to 4 numbers after the decimal.

I have tried to round the numbers within the queries and I get errors asking for parameters. I've also tried to round the numbers in the append queries where I move the final numbers to a summary table. When I do that, I get an error message that the database can't find the table I selected.

I'm not sure how or where it's best to add the rounding function so that my final output is in the format I need. Any help you can provide would be greatly appreciated!
Thank you

 

[Galaxiom]

Check your spelling of the fields and table names against what is being asked as parameters.

If there are no errors then the query might be corrupted. Copy the text from the SQL view into a new query.

 

[elna_kay]

Thank you for your response.

I also talked with a co-worker who provided me with the format of the rounding function I was looking for. In the queries, on the Field line, I entered the following: 'RoundCost: Round(Sum([SumOfSumOfTotal Cost]),2)'. When the query runs, the output is rounded to 2 decimal places and then when I append the info, my summary table is in the format I need.