How about Microsoft and its cluster of goofballs simply provide RoundUp and RoundDown functions that can be used in a query. SQL server provides a method to do it, so should Access.
I would think the syntax should be:
RoundDown([value],[number of decimal places])
Example1...