Results 1 to 4 of 4
  1. #1
    4 Star Lounger
    Join Date
    May 2002
    Location
    Roanoke, Virginia, USA
    Posts
    493
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Report Breaks (A2K SP-3)

    I have a report whose sorting and grouping is set to DepositDate Acscending

    The report has aDepositDate Header [DepositDate]. If Deposit Date is blank, it lists all the records that have no deposit dates and then breaks properly on those records that have DepositDates.

    I am trying to get the DepositDate Header to print "No Deposit Date" for those reords that do not have a Deposit Date

    I tried Nz([DepositDate], "No Deposit Date") and

    IIf(IsNull([DepositDate}, "No Deposit Date", [DepositDate])

    and neither accomplishes what I am trying to do.

    Any suggestions?

    Tom

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Report Breaks (A2K SP-3)

    Your first attempt should work out. Set the control source of the text box in the group header to

    =Nz([DepositDate], "No Deposit Date")

    Important points:
    1. Don't forget the = in front of the expression.
    2. Make sure that the text box is not named DepositDate. That would cause confusion, since the control source is dependent on DepositDate.

  3. #3
    4 Star Lounger
    Join Date
    May 2002
    Location
    Roanoke, Virginia, USA
    Posts
    493
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report Breaks (A2K SP-3)

    Thanks.

    I must be missing something.

    The lack of the = was a typo. The text box is named Text89.

    I will try to post a database tomorrow.

    Tom

  4. #4
    4 Star Lounger
    Join Date
    May 2002
    Location
    Roanoke, Virginia, USA
    Posts
    493
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report Breaks (A2K SP-3)

    Your item #2 got me searching and somehow another date field had been named DepositDate. No wonder there was confusion. I don't think I would have ever tracked it down with out your caveat.

    Thank again

    Tom

Posting Permissions

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