Re: Expression Not or Not Like



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.
.



Relevant Pages

  • Re: Cannot start Microsoft Office Outlook
    ... Thats the error I get everytime I start the Office Outlook ... I am running Microsoft Office 2003 on WIndows Vista ...
    (microsoft.public.outlook.installation)
  • Re: MULTIPLE COPIES OF SAME E-MAIL MESSAGES
    ... So do I in Outlook 2002 but didn't in Outlook 2000. ... I posted the same query ... Everytime I check e-mail with Outlook I get ... > Why is this happening and how do I fix it? ...
    (microsoft.public.outlook)
  • 1993 indy 500-- only starts when its been running
    ... off cleaning them and putting them back on in the warm garage. ... yesterday it took me 4 hrs of tinkering in order to get it running ... everytime i try to start it ... i make sure the volatage is over 12.2V as well so i no thats not it. ...
    (rec.sport.snowmobiles)
  • Re: 1993 indy 500-- only starts when its been running
    ... off cleaning them and putting them back on in the warm garage. ... yesterday it took me 4 hrs of tinkering in order to get it running ... everytime i try to start it ... i make sure the volatage is over 12.2V as well so i no thats not it. ...
    (rec.sport.snowmobiles)
  • RE: Multiple addition query Issue
    ... Yes thats right ...its relates to an accounting ... Are there times where you're supposed to have a bill total ... I have been attempting to query a table via both sql and vb in order to ...
    (microsoft.public.access.modulesdaovba)