Filter fileds with % or *

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 2 access databases, but for filtering a form, one uses % and the *,
were can i configure this to be all the same?
 
Hi

The following is from MS Access help:

The two ANSI SQL query modes, ANSI-89 and ANSI-92, are not compatible
and use different wildcard characters. For example, if you run:

An ANSI-89 SQL query in a database set to ANSI-92 query mode, such as:
SELECT * FROM Customers WHERE Country Like 'U*'
It returns all customers from a country/region named "U*", not all
countries/regions beginning with the letter "U", because the asterisk
(*) is not a wildcard character in ANSI-92 SQL.

An ANSI-92 SQL query in a database set to ANSI-89 query mode, such as:
SELECT * FROM Customers WHERE Country Like 'U%'
It returns all customers from a country/region named "U%", not all
countries/regions beginning with the letter "U", because the percent
sign (%) is not a wildcard character in ANSI-89 SQL.

When you create a Microsoft Access database, you need to decide which
query mode you are going to use because if you create a later query
under a different ANSI SQL query mode than the current mode of your
Access database, your query could produce runtime errors or unexpected
results.

James
 
Depending on your Access version but it should be available under the Menu
command Tools / Options / Tables_Queries tab / ANSI-92 pane.
 
Back
Top