|
| 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
March 16th, 2006, 05:17 PM
posted to microsoft.public.access.queries
|
|||
|
|||
"not like" query
I need to filter a query with something on the order of:
not like "R*" and not like "T*" and not null unfortunately, I believe there is no "not like" command in access other than in ADP. If I went the route of using , I would have to be explicit about each of the 30 possibilities as the paramater does not accept a wildcard. Suggestions? 
|
|
#2
March 16th, 2006, 05:25 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
"not like" query
'Not Like' works just find in MDBs, Brad. SELECT tblTest.TestText FROM tblTest WHERE (((tblTest.TestText) Not Like 'r*' And (tblTest.TestText) Not Like 't*' And (tblTest.TestText) Is Not Null); -- Brendan Reynolds Access MVP "Brad Hotlz" Brad wrote in message news  I need to filter a query with something on the order of: not like "R*" and not like "T*" and not null unfortunately, I believe there is no "not like" command in access other than in ADP. If I went the route of using , I would have to be explicit about each of the 30 possibilities as the paramater does not accept a wildcard. Suggestions?
|
|
#3
March 16th, 2006, 06:03 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
"not like" query
"not like" does not work in a query
"Brendan Reynolds" wrote: 'Not Like' works just find in MDBs, Brad. SELECT tblTest.TestText FROM tblTest WHERE (((tblTest.TestText) Not Like 'r*' And (tblTest.TestText) Not Like 't*' And (tblTest.TestText) Is Not Null); -- Brendan Reynolds Access MVP "Brad Hotlz" Brad wrote in message news I need to filter a query with something on the order of: not like "R*" and not like "T*" and not null unfortunately, I believe there is no "not like" command in access other than in ADP. If I went the route of using , I would have to be explicit about each of the 30 possibilities as the paramater does not accept a wildcard. Suggestions?
|
|
#4
March 16th, 2006, 06:07 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
"not like" query
My apologies - For some reason, which I have not yet figured out, the query I
was working on would not accept the "not Like" parameter. I created a new query and it worked just fine. Thank you. "Brendan Reynolds" wrote: 'Not Like' works just find in MDBs, Brad. SELECT tblTest.TestText FROM tblTest WHERE (((tblTest.TestText) Not Like 'r*' And (tblTest.TestText) Not Like 't*' And (tblTest.TestText) Is Not Null); -- Brendan Reynolds Access MVP "Brad Hotlz" Brad wrote in message news I need to filter a query with something on the order of: not like "R*" and not like "T*" and not null unfortunately, I believe there is no "not like" command in access other than in ADP. If I went the route of using , I would have to be explicit about each of the 30 possibilities as the paramater does not accept a wildcard. Suggestions?
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Toolbars, Drop-Down Menus | Rick | New Users | 1 | September 21st, 2005 11:17 AM |
| SQL query showing diff between actual and budget | Bon | Running & Setting Up Queries | 3 | August 25th, 2005 12:07 PM |
| Nested in-line Query | laura | Running & Setting Up Queries | 0 | February 11th, 2005 12:17 AM |
| Big number gives error! | Sara Mellen | Running & Setting Up Queries | 8 | October 11th, 2004 02:48 AM |
| Too Few Parameters error Mail Merge Access Parameter Query | Tony_VBACoder | Mailmerge | 3 | September 14th, 2004 12:15 PM |
Linear Mode
