How does "not equal" translate into Access Language
May 17, 2006 9:08 AM Subscribe
In Access (and Excel as well I would imagine) what is the symbol for "Not Equals"? I would imagine since = is equals there must be a symbol for everything excluding said parameter
posted by JonnyRotten to Computers & Internet (14 answers total)
I am in the process of teaching myself MS Access. I have made our excel based computer inventory into a Access database, and one of the fields is IP Address. The IP address field is either a number, or the word "storage" if its a PC that is no longer on our network.
I want to make a Query that only lists PCs with active IP addresses, and excludes all of the "Storage" PCs. I think I can do this in the criteria field in the design view of my query, but the example it gives me if I do a shift-F1 on the Criteria field is ="denmark".
So, how do I tell it not="denmark"?