How can I declare a variable that will contain value from by db

[RSX02]

Hi I have a field in my database that is declared as decimal(9)
I have to add two of them in VBA.
I have to declare 2 variables that can contain the data of my field.
How should I declare my variables?
Single
Double
anything else
???
Thanks id advance

 

[TLady]

Open Table that contains data you reffering to (in Design view) and look what datatype field is.
This will help I hope

Ask if need to be
TIA

 

[RSX02]

I'm not sure I understand what you mean?

 

[SQLBI]

Rsx02

It all depends on how big the numbers are going to get.

I personally try to avoid using Single and stick with Double, to prevent any possible overflows.



Leigh Moore
LJM Analysis Ltd

http://www.ljm-analysis.co.uk