I'm trying to select all of the records from a table where payment has not been made. So I wrote the following sql statement but it doesn't like the "" before the ORDER BY clause. I'm basically trying to say, give me all of the records where the payment type field is empty (blank or NULL). How do I write this? THanks! Here's my statement:<BR>"SELECT * FROM PCSALE WHERE Location Like 'Niagara Falls' AND Payment_Type = "" ORDER BY Last_Name"