CInt and Invalid Use of Null

[drewetzel]

Hi,



I have a query containing an expression that subtracts one date/time field from another. Once that action is performed I only want to see the positive outcomes and not the negatives. Since subtracting/adding date/time fields (I believe) results in a text output, I'm using the function CInt to convert the result to a number and then putting the criteria ">=0" on the field. When I run this query I get the error message "Invalid Use of Null". Help, anyone?

thanks,
Andrew

[Stingaway]

What function are you using to subtract the date fields?

[drewetzel]

This is my expression...

First Drop Factor: [Forms]![Frm_Sales Report]![Start Date]-[Advertising].[InHomeDate]

[Stingaway]

Try using a date diff function instead, it returns an integer value.

Examples can be found at:

http://www.techonthenet.com/access/f...e/datediff.php

[drewetzel]

That worked perfectly. Thanks a lot for the help.