F Frank Winston Jul 13, 2003 #1 How do I construct a query to count the number of records in a table where no value has been entered into a Date field?
How do I construct a query to count the number of records in a table where no value has been entered into a Date field?
O Oliver Gleß Jul 13, 2003 #2 Table Tabelle1 Field1: Name, String Field2: DOB, Date/Time SELECT Count(Tabelle1.Name) AS [CountResult] FROM Tabelle1 WHERE (((Tabelle1.DOB) Is Null));
Table Tabelle1 Field1: Name, String Field2: DOB, Date/Time SELECT Count(Tabelle1.Name) AS [CountResult] FROM Tabelle1 WHERE (((Tabelle1.DOB) Is Null));