InfoPath Dev

 thanks for the help!   i got it working finally!!  instead of using CInt, i used CDbl and i worked with the decimal values!   thanks again

 ok, i got it working.. i used totrandamt1 = CInt(rantamt1) + CInt(randamt2) etc..  How do i get the total field to show the full amount and not just a round figure (eg: 3.45 instead of 3)

 thank you for the help again! I have changed the field types to text (they were set to integer). I have 1 last problem! how do i add up the fields numbers? i have tried: Totrandamt1 = randamt1 + randamt2 + randamt3.   but this just shows the numbers in the fields and does not add them up.

 I have tried this code for the other fields, but im getting this error: "Schema validation found non-data type errors." I dont get the error on Randamt1, but get this error on the ones after..             Dim rate1 As ...

 Hi Alec, I have used your codeless method, but i get an error when i choose the first date, saying that some rules were not applied. Thanks again for the help!

 Hi mgarant, Thank you very much!! it works! would i do the same for adding up values? I would also like to know what to do if there is not value in the fields as i am going to have 3 different exchange rates and converting them into the Rand value. i Presume i would need an If statement, but im not sure how to go about doing ...

HI, I am trying to do calculations in infopath, but i cannot seem to get them working. I have little experience in infopath so im not sure what i am doing wrong. this is what i currently have: Dim rate1 As Integer Dim Randamt1 As Integer Dim foramt1 As Integer          Rate1 = ...

 this is what i have tried for the exchange amounts:               Dim rate1 As String             Dim Randamt1 As String             Dim foramt1 As ...

 i havent added the fields for the other exchange amounts, as i am trying to get one portion of it working..

 Hi, I am making an international expense claim form for a client. on the form, i have two date fields (date from and Date to). i also have a days field which has to work out the amount of days between the two dates. i have tried the datediff function but i cannot get it working. Is there possibly an easier way of doing this as i have no ...