Decimal places not enough

[Robert_DubYa]

I have a make table query and in the query I have an expresion that only
displaces up to 2 decimal places. I need this to extend to at least 6
decimal places (more would be better). I'm not shure what is going on with
this. In the properties it does not matter what I set the data type to.
Here is a copy of my exprersion:

TimePerPart: (Sum(([WLRUNL]*0.01)+([WLSETL]*0.01)))/([WAUORG]*0.01)

I have searched the message board first and have not found a question/answer
that deals with the same topic. Please help if you know what I'm doing wrong.

thanks
Robert

 

[Jeff Boyce]

Robert

Using a Make Table query limits the design of your 'made' table.

Another approach would be to create a table that is EXACTLY the definition
you want, then use queries to delete all existing records and to append new
records.

Regards

Jeff Boyce
Microsoft Office/Access MVP