[RESOLVED] currency

[elixir_5000]

i am using access database , i have 2 fields rate and quantity
what is the best data type in which these must be stored
i am having decimel values but if i use decimel as the dattype then it discards the digit after decimel

[ganeshmoorthy]

I would Use Double datatype for currencies

[Simply Me]

i am using access database , i have 2 fields rate and quantity
what is the best data type in which these must be stored
i am having decimel values but if i use decimel as the dattype then it discards the digit after decimel

What is your code to store the data in your table?

[Shuja Ali]

I will use Double for Rate and long for Quantity.

[elixir_5000]

val = "insert into data values('" & Text5 & "','" & Text2 & "','" & Text4 & "','" & Text23 & "','" & Text22 & "','" & Text21 & "','" & Text6 & "','" & Text7 & "','" & Text8 & "','" & Combo1 & "','" & Text9 & "','" & Text17 & "','" & Text14 & "','" & Text18 & "','" & Text15 & "','" & DTP1 & "','" & DT2 & "','" & Text10 & "','" & Text11 & "','" & Text19 & "','" & Combo3 & "','" & DTP3 & "','" & rs2("cbmbox") & "','" & Text3 & "')"

here text 14 contains rate
in the data base the rate is stored perfectly if i use memo or text but it then gives prob in crystal treport when i convert it to word