G
George
I am using Access 2002
I have a problem with using the asterisk wildcard in
Filter-by-Form in a Table in my database. To analyse the
the problem I copied the table to a new blank database and
deleted all fields except two: LASTNAME and FIRSTNAME. The
table includes three persons with last name JONES: TIM
JONES, TOM JONES, and FRED JONES. When I use Filter-by-
Form with search criteria last name "JONES" and first
name "T*", I do not find any matching records. If I do not
use any last name criteria with "T*" as the first name
criteria, I find all the records with first names starting
with "T" as I should. If I use last name criteria "JONES"
and first name criteria "T**" (double asterisks) I find
all the Jones with first name beginning with "T" (as I
should have with the single aterisk).
I created another table in this demo database with the
same fields and data. It works fine with the wildcard
characters working the way they should.
Any ideas about how to fix the defective table would be
much appreciated.
I have a problem with using the asterisk wildcard in
Filter-by-Form in a Table in my database. To analyse the
the problem I copied the table to a new blank database and
deleted all fields except two: LASTNAME and FIRSTNAME. The
table includes three persons with last name JONES: TIM
JONES, TOM JONES, and FRED JONES. When I use Filter-by-
Form with search criteria last name "JONES" and first
name "T*", I do not find any matching records. If I do not
use any last name criteria with "T*" as the first name
criteria, I find all the records with first names starting
with "T" as I should. If I use last name criteria "JONES"
and first name criteria "T**" (double asterisks) I find
all the Jones with first name beginning with "T" (as I
should have with the single aterisk).
I created another table in this demo database with the
same fields and data. It works fine with the wildcard
characters working the way they should.
Any ideas about how to fix the defective table would be
much appreciated.