Hello

I do a query that selects and sums some data.

Problem is if there is nothing to sum it will still return one row full of dbnulls.

This makes my program error when I try to compare with another number (because the value returned from the database is a null not a number)

How can I check? I treid.

If Not rsTrans.Fields("totalinc").Value = System.DBNull Then

But that did not work.

Thanks