I have a table that has the following data:
ID Name LastName 1 William Johns 2 John Adam 4 William Smith 3 Mark Stephan
I want to Find all those records that their Names are the same but there Last Names are different. so the result will be something like this:
ID Name LasName 1 William Johns 2 William Smith
What would be the MS. Access Query or method to find all these records?