Hi all,
In query grid, in the criteria section, when i type "?xen" to search "Axen" from the "Last Name" field, MS Access gives me an error message as:
" The expression you entered contains an invalid syntax, you may have entered an operand without an operator "
While when I type "*xen" or "A?en", it works fine.
Why does not MS Access takes "?" as the vey first wildcard character in the criteria ?
??
Tahir
In query grid, in the criteria section, when i type "?xen" to search "Axen" from the "Last Name" field, MS Access gives me an error message as:
" The expression you entered contains an invalid syntax, you may have entered an operand without an operator "
While when I type "*xen" or "A?en", it works fine.
Why does not MS Access takes "?" as the vey first wildcard character in the criteria ?
??
Tahir