RabSwinney
Technical User
I Have have a query being exported to microsoft excel, the problem I have is the decimal places are not the same as I have in access, I have the data fixed decimal places.
Thanks
Thanks
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Decimal Place problem
- Thread starter RabSwinney
- Start date
- Status
SkipVought
Programmer
Please explain. Are you using IMPLIED decimal?
Or is it .100 in Access and .1 in Excel? (SAME VALUE -- different FORMAT)
Skip,
[sub]
![[glasses]](/data/assets/smilies/glasses.gif "[glasses] [glasses]")
[red]Be Advised![/red] A chicken, who would drag a wagon across the road for 2 cents, is…POULTRY in motion to PULLET for a PALTRY amount!
![[tongue]](/data/assets/smilies/tongue.gif "[tongue] [tongue]")
[/sub]can you show us some examples of how
Leslie
Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual
Essential reading for anyone working with databases: The Fundamentals of Relational Database Design
?
Leslie
Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual
Essential reading for anyone working with databases: The Fundamentals of Relational Database Design
- Status
Similar threads
- Locked
- Question
