troubleshooting Question

MS Access SQL not returning what I expect

Avatar of dyarosh
dyarosh asked on
13 Comments1 Solution261 ViewsLast Modified:
I have an MS Access database with an Employees Table.  The Employees table has a field, PS58, that is a text field that contains a number or null.  I'm trying to format a query that will display all the records whose PS58 value is greater than 0.  I haven't been able to figure out the correct syntax for the query.  The SQL 1 select statement below gives me an Invalid Use of Null error.  
SELECT     EmployeeID, EmployerID, LastName, FirstName, PS58
FROM Employees
ORDER BY LastName, FirstName
Join our community to see this answer!
Unlock 1 Answer and 13 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 13 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros