Hi Sniffer,
Is that in anyways related to your other post
Can 2 recordsets be joined or searched?
If so, As Chris suggested, make the changes mentioned in RED below.
Code:
Dim iCnt
iCnt = 0
While NOT rs_A55report.EOF
While NOT rs_special.EOF
If rs_A55report("Email")= rs_special("Email_Address") then
'Display the data from rs_A55report
iCnt = iCnt + 1
End If
rs_special.MoveNext
Loop
rs_A55report.MoveNext
Loop
Response.write "Number of Records that matched the criteria : " & iCnt
Hope that helps.
Cheers!
_________________________
- Vijay G
Strive for Perfection