Results 1 to 3 of 3

Thread: #Error is null

  1. #1
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    Unhappy Unanswered: #Error is null

    I have this in a query so it will calculate ("=DateSerial(Year([FIRSTRENEWALDATE])+2,Month([FIRSTRENEWALDATE]),Day([FIRSTRENEWALDATE]))"
    its there to calculate the dates for me so I know when to renew. The only problem is its an expression so if its null on the form I cant edit it, just shows and #Error message if its left null. What would be a better expression to use , this one gives calculates the dates correctly, all I have to do is put it in the Second renewal expression and add a 4 to the month then it tells me when the second renewal is due. The renewals have to be at the end of the month and every 2 yrs? But all that info is not put in at once you have to put it in when the final is done thats when the FIRSTRENEWALDATE is calculated. Can anyone help pls??

  2. #2
    Join Date
    May 2004
    Location
    The Netherlands
    Posts
    52
    Just place the expression in an IIF-statement:

    IIf(IsNull(form!field!value);"";<here your expression>)

    Hopes this helps.

  3. #3
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    getting error

    thank you Robje I'm still getting and error message maybe I typed the expression incorrectly? IIF(IsNull(Form!Field!Value);" ";(DateSerial(Year([FIRSTRENEWALDATE])+2,Month([FIRSTRENEWALDATE]),Day([FIRSTRENEWALDATE]))

    I'm not sure

Posting Permissions

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