Refining criteria 1

[sbrash]

in running a query, is there any way that the system can match the information in column AJSVID [from one table] to EqpNbr_New [in a second column] if the information is not verbatim?

Ie.

AJSVID = 0004010505
EqpNbr_New = 4010505

Or

AJSVID = 0000012345
EqpNbr_New = 12345

Or

AJSVID = 0004010505
EqpNbr_New = 401050588888

Or

AJSVID = 0000012345
EqpNbr_New = 88812345888

 

[Rohdem]

Try this for your criteria:

like "*" & [EqpNbr_New] & "*" Mike Rohde
rohdem@marshallengines.com
"If builders built buildings the way programmers wrote programs, the first woodpecker to come along would destroy civilization!"