Number precision

[Ben]

Hi all,

I have a DoCmd.transferspreadsheet in Access
The query I use has three fields that are double, but I open the file in
Excel the precision is lost. So I forced the precision by using:

Format(mydoublefield1, "0.0000") as mydoublefield1

But now when I open the file in Excel, the numbers in the fields become
text with a "'" in front of each number. What did I do wrong?

Thanks for sharing your thoughts/suggestions.

Ben

 

[CrazyAccessProgrammer]

After you transfer your data to excel, did you try formatting the excel
fields with 2 (or more) decimal places?

 

[dymondjack]

Just thinking out loud here, but doesn't the Format() function return a String?

If I'm remembering that correctly, that may be your issue

--
Jack Leach
www.tristatemachine.com

- "First, get your information. Then, you can distort it at your leisure."
- Mark Twain

 

[Ben]

Jack,
I am sure, I have to check, that may be my problem.

Thank you.