467,894 Members | 1,768 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,894 developers. It's quick & easy.

Excluding data from a query?

This might be total newbie, and I apologize if it is, but it is making me insane.

I have a database with lots of tables, queries and reports (someone else made the database and I am now taking over and tweaking for customers).

Table contains student's grades, addresses, etc.
Customer wants an existing query to exclude all "w" grades.
The query uses several different tables, but the table containing grades is 'utbldefdata'.

Anyhow, in the query under grades (next to criteria) I write Not "w".
It runs once OK, but then I run it a second time and it shows me the 'w' grades again. Also, the word "Not" changes to "<>"

Any ideas?


Oct 6 '06 #1
  • viewed: 3707
1 Reply
SELECT * FROM utbldefdata WHERE grades <> 'w'
Oct 6 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

8 posts views Thread by duncan.lovett | last post: by
1 post views Thread by jennieiou | last post: by
reply views Thread by MrMoon | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.