max wrote:

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.

Perhaps you will need accuracy to five decimal places sometime? You

could maintain this and still link the tables using

JOIN ON Round(Table1.FieldName,1) = Table2.FieldName

If you make a new table or change the values in the original table you

may very well run into problems with keeping your data current.