Query all records with a date

[LanieB]

Hello all!!

I've got a database for grades. I'm trying to figure out what I need to place in this query to pull all records with any dates entered into that certain cell.



Some people have taken some classes, others haven't, I want to query all employees that have taken the class.

I can't figure out what to put to pull the records for all of the employees with a date entered.

AS ALWAYS, thank you for all your help

[LanieB]

I also have the same type of question for a TEXT field. They are assigned a series of numbers and letter from the company as an ID. How to I tell the query to search for all results that have 'any text' entered into that field.

[pbaldy]

SELECT *
FROM TableName
WHERE IsDate(FieldName)

[pbaldy]

WHERE FieldName Is Not Null

or if there could be zero length strings

WHERE Len(FieldName) > 0