Maintaining decimal places in text export

[mikew71]

I'm unable to maintain the 2 decimal places on records with whole numbers or rounding to one place while exporting a text file for an upload into a Business Objects report. So far I've tried without success,

1) Formatting export table as 'Standard' with 2 dec places
2) Using export specs (on which there was no option to declare decimal places)
2) Converting the numerical to text in table specs
3) Using the 'Round' function in the queries feeding the export table.

I've formatted the field using 'double' with 'Standard' format and two decimal places.

Has anybody come across this issue either in Business Objects or Access?

 

[PHV]

Have you tried the Format function in the exported query ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[mikew71]

Thanks, if you mean when running the three queries that feed the export table then yes, I've been setting the format on these to standard with two decimal places.

I'm not aware of anyway to format while exporting, is there a way besides export specifications (which I tried but could not declare decimal places)?

 

[PHV]

In the query, instead of :
SELECT myDoubleField, ...
Try this:
SELECT Format([myDoubleField], '0.00') AS myFormattedField, ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[mikew71]

Thanks, this locked the figures in as text format. BO upload appears to be sucessful.

Thanks very much for this.