Filter fileds with % or *

[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?

 

[James]

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

 

[Guest]

Hi James,

is there a place in MS Access where i can change the ANSI-SQL query mode?

JFC

 

[Van T. Dinh]

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