Recent content by 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...

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...

Good afternoon, I am new to the forum, although I've looked at posts before to see if my questions could be answered. I've been using Access for a couple years now, but usually try to make my databases way more complex than they need to be! One of my goals this year is to learn more SQL to...