Decimal places not enough

  • Thread starter Thread starter Robert_DubYa
  • Start date Start date
R

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
 
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
 
Back
Top