Re: Expression Not or Not Like
- From: CDMAPoster@xxxxxxxxxxxxxxxx
- Date: Mon, 10 Mar 2008 13:40:32 -0700 (PDT)
On Mar 10, 4:22 pm, rogers...@xxxxxxxxx wrote:
Hi.. Thanks for the prompt reply.
I tried to run the query. Everytime I use expression, for ex: Not Like
"ADVANCED" or Not "ADVANCED" the result is zero.
Thats not the right result. I don't know why
This is a shot in the dark.
In:
http://groups.google.com/group/comp.databases.ms-access/msg/6213c9498b2903dd
I said:
Like has a lower operator precedence than AND and could result in
certain SQL executions trying to perform the AND first.
James A. Fortune
CDMAPoster@xxxxxxxxxxxxxxxx
Although the help file system says that the sort order for an Outlook
2K3 Address Book can't be changed, I was able to change it using
Access.
.
- References:
- Expression Not or Not Like
- From: rogerscmg
- Re: Expression Not or Not Like
- From: fredg
- Re: Expression Not or Not Like
- From: rogerscmg
- Expression Not or Not Like
- Prev by Date: Re: Expression Not or Not Like
- Next by Date: Re: Expression Not or Not Like
- Previous by thread: Re: Expression Not or Not Like
- Next by thread: Re: Expression Not or Not Like
- Index(es):
Relevant Pages
|