Zergman Posted October 23, 2008 Share Posted October 23, 2008 Sorry if this might sound simple, but can't figure this one out. I have a column in a table that has various entries Example Option1 Option2 Option3 ... etc. What im trying to do is build a query that searches for all records excluding Option1. Just need a tally of how many records don't have Option 1 in them. Can't figure out how to do this ??? Quote Link to comment Share on other sites More sharing options...
trq Posted October 23, 2008 Share Posted October 23, 2008 SELECT COUNT(fld) AS tally FROM tbl WHERE fld != 'Option1'; Quote Link to comment Share on other sites More sharing options...
Zergman Posted October 23, 2008 Author Share Posted October 23, 2008 Beautiful, thanks for the help! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.