G Guest Nov 15, 2005 #1 using * as a wildcard is not working in a form based on a query? Anyone know why this could be? And the solutions
using * as a wildcard is not working in a form based on a query? Anyone know why this could be? And the solutions
J John Vinson Nov 15, 2005 #3 using * as a wildcard is not working in a form based on a query? Anyone know why this could be? And the solutions Click to expand... Either there's something wrong with the query (as Ofer says, please post the SQL - which we cannot see); or you have set the Database's Options to use SQL-92 syntax, which uses % rather than * as a wildcard. John W. Vinson[MVP]
using * as a wildcard is not working in a form based on a query? Anyone know why this could be? And the solutions Click to expand... Either there's something wrong with the query (as Ofer says, please post the SQL - which we cannot see); or you have set the Database's Options to use SQL-92 syntax, which uses % rather than * as a wildcard. John W. Vinson[MVP]