QUERY NON DUPLICATE

  • Thread starter Thread starter zyus
  • Start date Start date
Z

zyus

I have this sample record in my table

LNAME MYNAME
John John
Peter Petera
Alan Wilson

I want to look for data where LNAME<>MYNAME by the first spelling character.
In the above example i wanna get Alan & Wilson. Currrent i used Like A* in
LNAME and Not like A* in MYNAME.

Is there any shorter way to do it...Otherwise i would have to spell from A
to Z

TQ
 
I have this sample record in my table

LNAME MYNAME
John John
Peter Petera
Alan Wilson

I want to look for data where LNAME<>MYNAME by the first spelling character.
In the above example i wanna get Alan & Wilson. Currrent i used Like A* in
LNAME and Not like A* in MYNAME.

Is there any shorter way to do it...Otherwise i would have to spell from A
to Z

TQ
Click to expand...

A criterion on MYNAME of

NOT LIKE Left([LName], 1) & "*"

should do the trick.
 
Thank You John.....i need to learn a lot of tricks in access

John W. Vinson said:
I have this sample record in my table

LNAME MYNAME
John John
Peter Petera
Alan Wilson

I want to look for data where LNAME<>MYNAME by the first spelling character.
In the above example i wanna get Alan & Wilson. Currrent i used Like A* in
LNAME and Not like A* in MYNAME.

Is there any shorter way to do it...Otherwise i would have to spell from A
to Z

TQ
Click to expand...

A criterion on MYNAME of

NOT LIKE Left([LName], 1) & "*"

should do the trick.
Click to expand...
 
Back
Top