How should i make an SQL STATEMENT to view records from my database?

Question

i want to view records on my ms access database whose field (datereturned) value is empty.... how should i type the sql? please help...

Answer 1

select * from tablename where datereturned is null;

Hopefully, the column datereturned allows nulls. Otherwise, you'll have to specify whatever the default value is.