Query two tables and compare results

[Yesuslave]

Hi all,

OK, what I need to do is query two different tables at the same time. They will have two common pieces of data, a Social Security Number, and a UID. If both exist on both sheets, I would like Access to return a Msgbox with "Match" and if not return a msgbox with "No match." I can't seem to quite figure this one out.

Thanks for any help in advance,
Josh Wise

 

[Yesuslave]

Ok, so I figured this one out with VBA code. Basically, i just did this:

Function GetCounts(strSSN As String, strUID As String)
Dim intX
Dim intY
Dim strSN
Dim var






intX = DCount("[ssn]", "dbo_applicant", "[ssn] = '" & strSSN & "'")
intY = DCount("[SSN]", "Master List Table", "[SSN] = '" & strSSN & "'")

If intX <> 0 And intY <> 0 Then
MsgBox "There is a match"
Else
MsgBox "There is no match"
End If




End Function

Josh