Is there an Exact Function in Access 2002?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to compare two text fields in our database and want to view only
the ones that are not equal in a querry. I figured that I could use an exact
function just like Excell has but, since I am new to Access, I am not sure
how to set up this function (if it even exists). Does anyone have any
suggestions?
 
I'm not familiar with the Exact function, but I'm assuming you want to do a
case-sensitive comparison? If so, the following query should do it ...

SELECT tblTest2.*
FROM tbltest2
WHERE (((StrComp([TestText],[TestText2],0))=0));

.... where "tblTest2" is the name of your table, and TestText and TestText2
are the names of your two text fields. See StrComp function in the (VBA)
help file for details.
 
Back
Top