Query two fields
 

I need to compare two addresses to see if the address 1 is contained in
Address 2. If true, I do nothing, if false, I return the record/row
containing the different addresses.

Note: I need to complete this for a report at work today


--
Sayelarkpor
------------------------------------------------------------------------
Sayelarkpor's Profile: http://www.excelforum.com/member.php...o&userid=33819
View this thread: http://www.excelforum.com/showthread...hreadid=535961

Query two fields
 

have a look in vba help index for FINDNEXT

--
Don Guillett
SalesAid Software

"Sayelarkpor"
wrote in message
...

I need to compare two addresses to see if the address 1 is contained in
Address 2. If true, I do nothing, if false, I return the record/row
containing the different addresses.

Note: I need to complete this for a report at work today


--
Sayelarkpor
------------------------------------------------------------------------
Sayelarkpor's Profile:
http://www.excelforum.com/member.php...o&userid=33819
View this thread: http://www.excelforum.com/showthread...hreadid=535961