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

    Record Count (A2K SP-3)

    I have a report rptTotalReceipts that is based on qryDeposit. The report is qrouped by Deposit
    Date. There are some records that do not have deposit dates.

    In the Deposit Date footer of the report I have a text box as follows:

    =

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

    Re: Record Count (A2K SP-3)

    I can't reproduce the error in Access 2002 (I just get a blank), but you shouldn't use [DepositDate]=Null as test. Instead, try

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

    or

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

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

    Re: Record Count (A2K SP-3)

    Thanks for the proper syntax.

    When I test the query for null values and not null values in [DepositDate], it returns the proper records. Yet in the text box, it doesn't seem to recognize the null value. I will do some more testing when I get a few minutes. If I can't figure it how, I will post a short version of the database.

    Thanks again

    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: Record Count (A2K SP-3)

    I am still having trouble getting the blank records to print correctly.

    I am posting a stripped down version of the Database. The property ID Number that should be entered is 1.

    Your assistance would be greatly apprecaiate
    Attached Files Attached Files

Posting Permissions

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