Decimal place prob!!!

[bakeram]

I have a make table query and eventhough I have specified the field to be a fixed number with two decimal places, when the query is executed and the table is created, the number still comes out as a number with about 8 or 9 decimal places, can anyone help??? Thanks

 

[Norie]

As far as I know a make table query won't carry over formatting.

Wny not create a table with the fields and formatting you want?

Then rather than a make-table query use an append query.

This might not be suitable for your needs but it is one answer.

 

[bakeram]

That is a good idea,

thanks alot,

surely there is a way though??????

 

[Norie]

I think the only other way would involve VB coding.

 

[bat17]

you could probably do it using functions to fix the decimals

fixedCInt([myValue]*100))/100

Not tested but may work

HTH

Pter