dynamic table creation problem
dynamic table creation problem
(OP)
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
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
RE: dynamic table creation problem
Column2: Format([MyField],"0.00000")
HTH
Joe Miller
joe.miller@flotech.net