<div>
you can also use<br />
<br />
StrComp([LookupID],[Lookup<wbr />Value], 1)
</div>


you can also use

StrComp([LookupID],[LookupValue], 1)

<div>
have you tried doing a C&amp;R, <br />
looked for missing references<br />
<br />
DEBUG&gt;Compile and correct any errors
</div>


have you tried doing a C&R,
looked for missing references

DEBUG>Compile and correct any errors

<div>
<div class="content wysiwyg-content">
This should be so easy as I searched onoline and what I have is supposed to work, but I keep getting #Func as the result. &nbsp;All I want to know is if tlkLookupValues = tlkLookupID.<br />
<br />
SELECT tlkLookupValues.LookUpID, tlkLookupValues.LookupValu<wbr />e, StrComp([LookupID],[Lookup<wbr />Value]) AS Different<br />
FROM tlkLookupValues;
</div>
</div>


This should be so easy as I searched onoline and what I have is supposed to work, but I keep getting #Func as the result.  All I want to know is if tlkLookupValues = tlkLookupID.

SELECT tlkLookupValues.LookUpID, tlkLookupValues.LookupValue, StrComp([LookupID],[LookupValue]) AS Different
FROM tlkLookupValues;

StrComp inACCESS 2010 query not returning results

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Programming includes both the specifics of the language you’re using, like Visual Basic, .NET, Java and others, but also the best practices in user experience and interfaces and the management of projects, version control and development. Other programming topics are related to web and cloud development and system and hardware programming.

Programming

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.