access

[iansmithwolves]

how do i find identical entries of 10 letters or more in a query?

 

[SkipVought]

Hi,

Could you be more specific, please?

Are the values you are comparing in the same row or different rows?

What do you mean by, "...10 letters or more..."? Could that include characters like SPACE, DASH or numeric characters?

Skip,
[sub]
To be safe on the [red]FOURTH[/red],
Don't take a [red]FIFTH[/red] on the [red]THIRD[/red]
Or you might not come [red]FORTH[/red] on the [red]FIFTH[/red]
[red][highlight blue]FORTH[/highlight][/red][white][highlight red]WITH[/highlight][/white] [/sub]

 

[fneily]

And why is this not posted in Microsoft: Access Queries and JET SQL?