tahirih
asked on
Access - find exact match on text fields
Hi,
What is the most efficient manner to find or query where there is not an exact match in a text field in Access. For example, a 2010 file, the field is "the rainbow was bright" and 2011, the field says "the rainbow was bright and fit the entire sky."
I want to be able to flag that these two fields are not the same.
Thank you
What is the most efficient manner to find or query where there is not an exact match in a text field in Access. For example, a 2010 file, the field is "the rainbow was bright" and 2011, the field says "the rainbow was bright and fit the entire sky."
I want to be able to flag that these two fields are not the same.
Thank you
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
To be fair, Ray brings up a good point.
I know that every situation is different, ...but generally it is clearer to most people to see when something "Is", rather than when it "Is Not"
So I have no issue with you accepting his post...
Jeff
Thanks Jeff: Especially when the "Is Not" is "Is Not" ;-)
ASKER
Thank you everyone - please give me a bit to try everything - and I will finsih this question.
ASKER
Thank you both
;-)
Thanks, glad to help
SELECT Fld1, Fld2, Fld1=Fld2 AS Same FROM myTable