dynamic table creation problem

[Guest_imported]

Hello,

I'm have table that gets created by a makeTable query, after it's not needed it get deleted.

The table get created with two columns, the second one holds a number. Is there a way of getting the second column to format to 5 decimal places, instead of auto, everytime the table is created?

Thanks for the help in advance

Kris

 

[JoeMiller]

You can force the make table query to display the number using the format function:

Column2: Format([MyField],"0.00000&quot

HTH Joe Miller
joe.miller@flotech.net