There is probably an easy answer to this but I can't figure it out. I
have a table with fields of numbers that are 5 or more decimals long.
i.e. 47.19568 I want to round these numbers to 1 decimal. i.e. 47.2
I have tried to create a query and set that field to 1 decimal and when
I look at it in datasheet view, it displays the number I want. The
reason I need to do this is I have another table with numbers to 1
decimal and I need to link these two fields together in a query.
Access is treating 47.2 as the original underlying number and it
returns no results when I run the query. I tried to do a make table,
but the new table still has the original 5 decimal number. Is there a
way to set the original table field properties to automatically change
these to 1 decimal numbers? Or make a new table with just the rounded
numbers? Any help is greatly appreciated.