How do you compare text fields that are different length?
I have two fields, [Comment] (21 characters) and [ChgComment] (# of characters in field 0-21).
The two fields usually contain the same characters, only the length is different.
Under the Criteria for [Comment] I entered <>[ChgComment]
I'm looking for records where the info in the two fields are different, but because the field lengths are different my query returns all records as different.
The database is application driven, so I can't change the field lengths.
Any help would be appreciated.
I have two fields, [Comment] (21 characters) and [ChgComment] (# of characters in field 0-21).
The two fields usually contain the same characters, only the length is different.
Under the Criteria for [Comment] I entered <>[ChgComment]
I'm looking for records where the info in the two fields are different, but because the field lengths are different my query returns all records as different.
The database is application driven, so I can't change the field lengths.
Any help would be appreciated.
