well, for starters, use * instead of %..... Access used the * wildcard, instead of the usual % in SQL.... also, it looks like there's a space before the last wildcard.... which may cause problems...