Welcome to City-Data.com Forum!
U.S. CitiesCity-Data Forum Index
Go Back   City-Data Forum > General Forums > Science and Technology > Computers
 [Register]
Please register to participate in our discussions with 2 million other members - it's free and quick! Some forums can only be seen by registered members. After you create your account, you'll be able to customize options and access all our 15,000 new posts/day with fewer ads.
View detailed profile (Advanced) or search
site with Google Custom Search

Search Forums  (Advanced)
 
Old 05-23-2010, 12:12 AM
 
484 posts, read 2,211,745 times
Reputation: 314

Advertisements

Hey I am having a problem with an assignment on Access if anyone can help me...
I am trying to modify a query in which im trying to make the criteria not equal to 20, 30, and 40.
Ive already made a querey to run specifically for 20,30, and 40......but not vice versa.
I figured out the not equal sign is <> but I can only do it for one number such as <>20 .......
If anyone knows how to combine the not equal let me know.....
Thank you
Reply With Quote Quick reply to this message

 
Old 05-23-2010, 12:18 AM
 
Location: Covington County, Alabama
259,024 posts, read 90,727,649 times
Reputation: 138568
<>20 and <> 30 and <> 40


try that. Rusty bus Access and SQL server used to feed me.
Reply With Quote Quick reply to this message
 
Old 05-23-2010, 01:06 AM
 
484 posts, read 2,211,745 times
Reputation: 314
ehehehe i was playing around with it in SQL and figured it out but thats the answer!!!!
thank u nomadicus u are the best! =]
Reply With Quote Quick reply to this message
Please register to post and access all features of our very popular forum. It is free and quick. Over $68,000 in prizes has already been given out to active posters on our forum. Additional giveaways are planned.

Detailed information about all U.S. cities, counties, and zip codes on our site: City-data.com.


Reply
Please update this thread with any new information or opinions. This open thread is still read by thousands of people, so we encourage all additional points of view.

Quick Reply
Message:


Over $104,000 in prizes was already given out to active posters on our forum and additional giveaways are planned!

Go Back   City-Data Forum > General Forums > Science and Technology > Computers
Similar Threads

All times are GMT -6.

© 2005-2024, Advameg, Inc. · Please obey Forum Rules · Terms of Use and Privacy Policy · Bug Bounty

City-Data.com - Contact Us - Archive 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37 - Top