|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
October 29th, 2008, 02:19 PM
posted to microsoft.public.access.queries
|
|||
|
|||
% sign in access
Does access accepts the "%" sign for missing values in a query?
|
|
#2
October 29th, 2008, 02:43 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
% sign in access
Dodzie99 wrote:
Does access accepts the "%" sign for missing values in a query? If you are talking about wildcards in LIKE statements, then no. Jet requires the DOS-like wildcards: * and ?. The exception is if you are using ADO to execute a query, then you need to use the ODBC wildcards: % and _. -- HTH, Bob Barrows
|
|
#3
October 29th, 2008, 02:49 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
% sign in access
I believe you are talking about wildcards - no. Use question mark for
single character, asterisk for multiple character, and # (number sign) for numbers only. -- KARL DEWEY Build a little - Test a little "Dodzie99" wrote: Does access accepts the "%" sign for missing values in a query?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
