[mso] another access question
- From: "Rocky Fithian " <rockyfit@xxxxxxxxxxx>
- To: mso@xxxxxxxxxxxxx
- Date: Thu, 21 Nov 2002 19:17:06 -0500
It's me again with questions on Access. I have a query setup on
one field of a database with 214 records. In the field I have date
like Dec.01 or Oct. 02. But in some I have Pos or Empl or NA, but
these are very few out of 214 rows. I have setup criteria like this: Is
Null Or like "*02" and it worked for what I wanted. Now I need to
have it pick out all records that are Null or not like 02 or not like
Pos or not like Empl or not like NA. I can not get it to work and
only pick out the records that are not like those things. How do I
setup the criteria to make it not pick those things? I have tried by
putting in: Is Null Or Not Like *02" Or Not Like "Pos" Or Not Like
"Empl" Or Not Like "NA" and when I do I get all 214 records. What
I'm I doing wrong?
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).
//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:
- » [mso] another access question
