TransferText defaulting to 8 decimal points

[Newie]

Hi,

Hope some-one can help as this is driving me crazy !

I have a Table with a Field set to Number, Single, Fixed, 2 Decimal points in which I enter Hours (ie 11.25) then at some point I want to extract those new entries to create a Text file transfer.
I have a Macro which extracts those new entries from the main Table and copies/appends them to a new Table which contains only the new data I need to create the File to upload into a Payroll system (using TransferText option).
It all works well EXCEPT, the File it creates insists on showing 8 decimal points and I just cannot get it to show 2 only.
I have tried using a calculated field, setting the secondary Table field to Text, Googling the answer but STILL it insists on showing 8 decimal points, I have absolutely no idea why or where these 8 decimals are coming from.

Can some-one help ?

Newie

 

[jdraw]

Run a query against that field

Round(yourfield,2)

 

[Newie]

Hi jdraw,

Is that it/all !!!!!!

I was having so much trouble that I expected the answer to be a very long winded/complex one ....?

Your reply is very much appreciated........thank you !

Steve