[mso] Re: Access 2000 query question :VSMail MX3

Rocky,

That should also work.  I didn't know what other data you had.  Is there any
reason you have the dates like this?  The database would probably work much
more efficiently if you would assign a date value to the field in question.
Then you could simply do a search for whatever date range you wanted.

James

-----Original Message-----
From: Rocky Fithian [mailto:rockyfit@xxxxxxxxxxx]
Sent: Sunday, November 24, 2002 1:18 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Access 2000 query question :VSMail MX3



James La Borde you sent an answer to my query, but it didn't work.  
Here was the question.  I have one field I want to search in the 
database with 214 records and in it are 4 things I don't want to find 
in the query. I do want to find the null records plus anything other 
than these 4.  You sent this.  Is Null And Not Like "*02" And <> 
"Pos" And <> "Empl" And <> "NA".  Those where the 4 things I 
didn't want to find.  It didn't find anything.
I did the search with Is Null And not like "*02" and got the records I 
wanted, (there were 36 or them) but also got 25 of the others I 
didn't want.
Hope I'm explaining this so you understand what I'm trying to do?
There are dates in 99, 00, 01 and I want to find out who those 
people are so we can get them to a scheduled test day.
IDEA !!!!!!!!!!!
Wouldn't this work better if I said: Is Null And Like "*99" And Like 
"*00" And Like "*01".  That way it wouldn't find anything but those 
years.  Am I gaining on it now?
Rocky Fithian  K2LN
If God doesn't seem near, who moved?
To check my sites click the link below.
http://web.sccoast.net/users/rockyfit/WebPageLinks.htm

*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to 
mso-request@xxxxxxxxxxxxx?Subject=unsubscribe

Or, visit the group's homepage and use the dropdown menu.  This will also
allow you to change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation
with instructions.  Once you are a member of the files group, you can go
here to upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to 
mso-request@xxxxxxxxxxxxx?Subject=unsubscribe

Or, visit the group's homepage and use the dropdown menu.  This will also allow 
you to change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a 
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with 
instructions.  Once you are a member of the files group, you can go here to 
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************

Other related posts: