using * as a wildcard is not working in a form based on a query?

C

Chickadees98

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

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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Repeated phrases wildcard? 1
Using FIND to highlight text (with dashes) 4
stlinkcriteria syntax. multiple fields and wildcards 5
DLookup in Continuous form 0
Wildcard Search 2
Automation of scanned file storage based on content 0
Find/Replace MSWord wildcard characters from within Excel 6
Calculation Based on Dynamic Variables (What-if Scenario) 0

Top