Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Posts
    2

    Question Unanswered: Forecasting dates in designview (ACCESS 2000)

    I have created a table in which I want my query to meet two criteria to be true. I want the query to forecast 30 days out from today's date searching only one (date) field and if a second field Is Null the statement is true. (Both have to be met to be true) I have the second part working but am having difficulty with the first part. This is what I have:

    Condition1: IIf(Date() Between [NEXT PERFORMANCE REPORT] And DateAdd("d",30,[NEXT PERFORMANCE REPORT]) And [date rcvd] Is Null,False)

    I have been working on this for days and any assistance would be greatly appreciated.

  2. #2
    Join Date
    Aug 2003
    Posts
    2

    Smile Re: Forecasting dates in designview (ACCESS 2000)

    Contacted a friend back in the States and together we determined the statement was incorrect and that it was adding 30 days to the [next report date] versus Date(). Also reset the date() format in in regional settings.

    Correct statement:

    Condition1: IIf([NEXT PERFORMANCE REPORT]between Date() And DateAdd("d",30,Date()) And [date rcvd] Is Null,True,False)

Posting Permissions

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