Hello,

Can anyone tell me the VBScript syntax needed to compare two fields values?
I want know how I do this in a table from a IDC

I've tried
----------------------------------------
Field3.value = field1.value + field2.value      
----------------------------------------
This has given me incorrect results..............

Is it supposed to work?

To compare to fields shouldn't you be using an IF statement as in

    If (field1.value = field2.value) then
        Proc1
    else
        Proc2
    End If

I believe your code (Field3.value = field1.value + field2.value) is
concatenating the string values from field1 and field2 and putting the resulting
string into Field3.
--
Richard Dill - Forum Host
Software Development Forum - ComputingCentral
http://computingcentral.msn.com/forums/softwaredevelopment