compare two fields values 
Author Message
 compare two fields values


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?

Mon, 17 Jul 2000 03:00:00 GMT  
 compare two fields values

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

    If (field1.value = field2.value) then
    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

Mon, 17 Jul 2000 03:00:00 GMT  
 [ 2 post ] 

 Relevant Pages 

1. comparing field values from two different access databases

2. Form validation: comparing two text fields

3. Can't compare two values...

4. Compare value for two different string

5. Comparing two values

6. Comparing two values which may be Null

7. comparing two integer values don't work

8. comparing data in specific fields from two tables ???

9. Comparing two data fields in Access through Visual Basic

10. Key field violation when comparing two tables

11. VB - Compare two list box items - display the matched fields in list3

12. VB - Compare two list box items - display the matched fields in list3


Powered by phpBB® Forum Software