G Guest Nov 12, 2004 #1 I would like to search the same field in every record in teh database to make sure it is not blank.
F fredg Nov 12, 2004 #2 I would like to search the same field in every record in teh database to make sure it is not blank. Click to expand... You could create a query showing all the records. As criteria for the field you wish to check use: Is Null Only the Null records will be returned. You could also use your Form's 'Filter by Form' or 'Filter by Selection' tool button to filter for all the Null records.
I would like to search the same field in every record in teh database to make sure it is not blank. Click to expand... You could create a query showing all the records. As criteria for the field you wish to check use: Is Null Only the Null records will be returned. You could also use your Form's 'Filter by Form' or 'Filter by Selection' tool button to filter for all the Null records.
J John Nurick Nov 12, 2004 #3 Hi Siggie, Use a select query with a criterion of Is Null on the field in question. The SQL view of the query will look like this: SELECT * FROM MyTable WHERE (MyTable.MyField IS NULL);
Hi Siggie, Use a select query with a criterion of Is Null on the field in question. The SQL view of the query will look like this: SELECT * FROM MyTable WHERE (MyTable.MyField IS NULL);
