[mso] Another Access Question
- From: "Rocky Fithian " <rockyfit@xxxxxxxxxxx>
- To: mso@xxxxxxxxxxxxx
- Date: Thu, 21 Nov 2002 22:18:05 -0500
I don't know if I have sent this to the list or not today. Head not on
correctly today.
I have a query setup on one field of a database with 214 records. In
the field I have data 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?
Thanks for any help.
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
