Storage of numbers

[sven2]

Hello,

I need to store numbers in a table between 0 and 9999,99.

What kind of type should i use?

I have tried decimal but I still get an error!

Thanks in advance,
Sven

 

[pbaldy]

What error? Decimal should work, but you can try Money.

 

[MSAccessRookie]

SQL Server Data Types and their associated ranges

The Link below has a table of Data Types and their associated ranges

http://www.teratrax.com/sql_guide/data_types/sql_server_data_types.html