Make table decimal place

[Robert_DubYa]

I have a make table query that is truncating at the nearest hundredths place.
If I just view the query it runs fine (from the view button), but when I run
it the table only shows 2 decimal places.

Example when run in "View" mode:

..039202

Example from the table output:

..03

The data is coming from the following expression:

Cycle Per: Sum([Machine Time])/[Qty]

How can I get this to go out to more decimal places. I have tried changing
the format to general number and that does not work. When I change to fixed
there is no place to enter the number of decimals.

thanks,
Robert

 

[Huber57]

Robert,

Try this:

Cycle Per: Format(Sum([Machine Time])/[Qty],#.####)

That should work.