Unanswered: WHERE x = x except if x = NULL then show all records
Hi guys, hope someone can help... I am pulling records from a simple access DB where account number of login = account number of payments table then show record. However i am trying to achieve if the account number = "NULL ENTRY" then show all records in the Payments table
here is my code so far
"SELECT * FROM Payments WHERE Payments.AccNumber = " & AccNum & " ORDER BY DateEntered"