Members 2bLikeJesus Posted March 2, 2014 Members Share Posted March 2, 2014 I hate to ask on this forum but at this hour of the night on a Saturday I am desperate for someone knowledgeable in SQL. I am supposed to create a SQL query for a multi-valued field [client type] that does NOT include one of the 3 choices. The choices in the field are "Ret", "Ser" or "Man". I am to make a SQL query that excludes "Man" from the Query. No matter what I have tried I keep getting a error message stating "The multi-valued field "[client type] cannot be used in a WHERE or HAVING clause. This is for my homework in Access 2010 Comprehensive. Bro. Garry or...Select [member name], [first name] From [members] Where [first name] like 'G*'; Link to comment Share on other sites More sharing options...
Members Donillo Posted March 2, 2014 Members Share Posted March 2, 2014 Can you use the query wizard or do you have to write in query language. You are essentially creating a filter that excludes"man". If you use the wizard you can open in SQL and see how its structured. Link to comment Share on other sites More sharing options...
Members 2bLikeJesus Posted March 2, 2014 Author Members Share Posted March 2, 2014 Can you use the query wizard or do you have to write in query language. You are essentially creating a filter that excludes"man". If you use the wizard you can open in SQL and see how its structured. YIPPEE! You DA MAN!! That worked! I have a cruel professor that is trying to convince us that SQL is much more efficient and easier than just using the GUI. Link to comment Share on other sites More sharing options...
Members Donillo Posted March 5, 2014 Members Share Posted March 5, 2014 Thanks 2b. Glad I could help Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.