Query for records that do not meet criteria

[survivo01]

I have a table called enroll
The times are class times inmates are already in
I need to enroll people who are open at 715 . If I query for the time =715 this gives me the people I cannot use. Leaving the rest availabe. I need a list of those who are available. If I query for <>715 it gives me the list of the people that I need but they might have a 715class

Id1	645
id2	715
id3	945

[ssanfu]

Would you post the SQL for your query?

What is the field type of the field that has the time? And the field name?

Do not use "Time" as an object name - it is a reserved word (and it is not very descriptive). Here is a list of reserved words:
http://allenbrowne.com/AppIssueBadWord.html

[survivo01]

I realized I was trying to pull up records that don't exist. When I changed my query to only pull up records that don't meet the time of my class I was okay. Thanks for looking and I changed time to time start

[ssanfu]

Great!

(you should also try to avoid using spaces on names)