i need somwe help

[Kamal]

I'm working now on old Database and trying to normalize
this database.
The name field in this database is full with names between
brackets () and i'm trying to make Query that can get me
those records which has the names with these brackets only
Can i get the answer for it?

KamalM.

 

[Jim/Chris]

in query criteria
Like "("&"*"
or
Like "*"&")"
This will get you the left ones or right ones

Jim