Data Types Question and Help

Hi Experts,
I dont want to use money data type because the money symbol pops into the
the grid but yet i am little uncomfortable with double - my calculations are
likely to go upto 50 Millions and cents rounded off to 4 decimal. Can you
please make a suggestion in this regard. Your help would be greatly
appreciated
Best Regards
Manish Sawjiani
Three Cheers to Technet for the Help!
How about a suitable DECIMAL() or NUMERIC() datatype?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Manish Sawjiani" <ManishSawjiani@.discussions.microsoft.com> wrote in message
news:EA8D18EF-C8B7-45D7-A189-3F751B4FD491@.microsoft.com...
> Hi Experts,
> I dont want to use money data type because the money symbol pops into the
> the grid but yet i am little uncomfortable with double - my calculations are
> likely to go upto 50 Millions and cents rounded off to 4 decimal. Can you
> please make a suggestion in this regard. Your help would be greatly
> appreciated
> Best Regards
> Manish Sawjiani
> --
> Three Cheers to Technet for the Help!

Data Types Question and Help

Hi Experts,
I dont want to use money data type because the money symbol pops into the
the grid but yet i am little uncomfortable with double - my calculations are
likely to go upto 50 Millions and cents rounded off to 4 decimal. Can you
please make a suggestion in this regard. Your help would be greatly
appreciated
Best Regards
Manish Sawjiani
--
Three Cheers to Technet for the Help!How about a suitable DECIMAL() or NUMERIC() datatype?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Manish Sawjiani" <ManishSawjiani@.discussions.microsoft.com> wrote in message
news:EA8D18EF-C8B7-45D7-A189-3F751B4FD491@.microsoft.com...
> Hi Experts,
> I dont want to use money data type because the money symbol pops into the
> the grid but yet i am little uncomfortable with double - my calculations are
> likely to go upto 50 Millions and cents rounded off to 4 decimal. Can you
> please make a suggestion in this regard. Your help would be greatly
> appreciated
> Best Regards
> Manish Sawjiani
> --
> Three Cheers to Technet for the Help!

Data Types Question and Help

Hi Experts,
I dont want to use money data type because the money symbol pops into the
the grid but yet i am little uncomfortable with double - my calculations are
likely to go upto 50 Millions and cents rounded off to 4 decimal. Can you
please make a suggestion in this regard. Your help would be greatly
appreciated
Best Regards
Manish Sawjiani
--
Three Cheers to technet for the Help!How about a suitable DECIMAL() or NUMERIC() datatype?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Manish Sawjiani" <ManishSawjiani@.discussions.microsoft.com> wrote in messag
e
news:EA8D18EF-C8B7-45D7-A189-3F751B4FD491@.microsoft.com...
> Hi Experts,
> I dont want to use money data type because the money symbol pops into the
> the grid but yet i am little uncomfortable with double - my calculations a
re
> likely to go upto 50 Millions and cents rounded off to 4 decimal. Can you
> please make a suggestion in this regard. Your help would be greatly
> appreciated
> Best Regards
> Manish Sawjiani
> --
> Three Cheers to technet for the Help!

Data type conversion

Does anyone knows which data type conversion is better to use for
numeric/double in Access?
When upsizing or using dts, sql server uses float with 8 precision. Should
it better be decimal with 2 digit left and 2 digits right the comma.
ThxIf float-8 does the job, then there's no reason not to use it. You should
format the output at runtime, not when you store it, so you're okay.
- Wm
--
William Morris
Product Development, Seritas LLC
Kansas City, Missouri
"Ezekiël" <ezekiel@.lycos.nl> wrote in message
news:%23jeq61D3DHA.1760@.TK2MSFTNGP10.phx.gbl...
> Does anyone knows which data type conversion is better to use for
> numeric/double in Access?
> When upsizing or using dts, sql server uses float with 8 precision. Should
> it better be decimal with 2 digit left and 2 digits right the comma.
> Thx
>

Data type conversion

Does anyone knows which data type conversion is better to use for
numeric/double in Access?
When upsizing or using dts, sql server uses float with 8 precision. Should
it better be decimal with 2 digit left and 2 digits right the comma.
ThxIf float-8 does the job, then there's no reason not to use it. You should
format the output at runtime, not when you store it, so you're okay.
- Wm
--
William Morris
Product Development, Seritas LLC
Kansas City, Missouri
"Ezekil" <ezekiel@.lycos.nl> wrote in message
news:%23jeq61D3DHA.1760@.TK2MSFTNGP10.phx.gbl...

quote:

---

> Does anyone knows which data type conversion is better to use for
> numeric/double in Access?
> When upsizing or using dts, sql server uses float with 8 precision. Should
> it better be decimal with 2 digit left and 2 digits right the comma.
> Thx
>

---