Results 1 to 3 of 3

Thread: null handling

  1. #1
    Join Date
    Apr 2002
    Location
    TX
    Posts
    34

    Unanswered: null handling

    how do I say this in a query...

    if enddate.value is null then
    date() - beginingdate
    else
    enddate - beginingdate
    endif

    I'm trying to find usage days but if the equipment is still in use, then I want to show the current usage in days, it seems like it would be easier to do this in a query for later reports than on a form. Anyone know how I should go about it?

  2. #2
    Join Date
    Nov 2001
    Posts
    336
    Tips:

    1. In queries you can use IIF() function.
    2. Use datediff() function to calculate difference between two dates.

    Igor

  3. #3
    Join Date
    Apr 2002
    Location
    TX
    Posts
    34
    thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •