.NET GENES

Here's a simple demonstration of sql in MySQL where you can retrieve a record from a previous date. select sum (data_gathered) as data_gatherer, name from tblctivity where name like '%prgGatherer1.xml%' and (date(rec_date) = (CURDATE() - 1));

Assuming QuantityPerUnit is the field to be tested. -- return products with no null values select * from products where QuantityPerUnit is not null ; -- return products with null values select * from products where isnull (QuantityPerUnit);