I have the following statement in a table that has a combo box field for selecting a creator. However, I only want it to display the creators that are of the type "sculpter":
SELECT tblCreator.CreatorID, tblCreator.CreatorName, tblCreator.CreatorType FROM tblCreator ORDER BY tblCreator.CreatorName WHERE tblCreator.CreatorType = "Sculpter";
which I thought would give me the list of creators WHERE the types are Sculpters. I get back blanks. I havent used Where all that much in my statements. Can anyone tell me what is wrong with this syntax? All the text I read seemed to indicate that in order to filter for a text description I needed to use WHERE after the From and put it in quotes. I tried single quotes as well. Help?