calculations using VB

[michael goodall]

i am trying to add the values in 3 text boxes (numbers in each) but it
is just combining them, ie i want 3+4+7, but access returns 347.
the code i am using is:
Me.Total_amount_of_ram.Value = Me.quantity_of_ram__slot_1_.Value +
Me.quantity_of_ram__slot_2_.Value + Me.quantity_of_ram__slot_3_.Value

has anyone any tips or pointers that could help me?
many thanks michael

 

[Bill Mosca, MS Access MVP]

Adding text boxes can yield unexpected results as the value is actually a
variant. It is best to convert the values to a numeric data type first as
in:
Me.Total_amount_of_ram.Value = CDbl(Me.quantity_of_ram__slot_1_.Value) +
CDbl(Me.quantity_of_ram__slot_2_.Value) +
CDbl(Me.quantity_of_ram__slot_3_.Value)

 

[michael goodall]

thanks very much,
michael

 

[michael goodall]

thanks very much,
michael

 

[Guest]

Hi Michael,

Your equation seems correct to me. What is the underlying data type for
these fields (text or numeric)?


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________