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

    Reports Breaks (A2K SP-3)

    I currently have a rptIncomePosting whose data source is qryRentCalcNoReceivable. The
    Sourting and Grouping is DepositDate-Ascending, RentPaidDate-Ascending, CustomerID-
    Ascending.

    The report currently subtotals by DepositDate.

    The query consists of cash type records (cash, checks, traveler checks) where money in deposited
    in the bank and thus have a DepositDate and a RentPaidDate. There are also credit card records
    which have a RentPaidDate but no DepositDate. Since the DepositDate is blank on all credit card
    records they are listed together at the beginning of the report as a group with no DepositDate
    Header.

    Is there a way to make the report first subtotal by RentPaidDate for those records without a
    DepositDate followed by subtotals by DepositDate for those records with a Deposit Date. I
    understand there will be duplicate dates in the two different sections.

    The report also has Grand Totals for many currency fields which are needed; otherwise, we could
    use 2 separate reports.
    Attached Files Attached Files

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

    Re: Reports Breaks (A2K SP-3)

    You could set the Field/Expression for the group level and the control source of the Text89 text box in the group header to

    =IIf(IsNull([DepositDate]),[RentPaidDate],[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: Reports Breaks (A2K SP-3)

    Many thanks. Your solution worked perfectly.

    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: Reports Breaks (A2K SP-3)

    The Accounting Department says that what they need is a listing of all records without DepositsDates followed by a listing of those records with Deposits Dates.

    The solution we have now put both types of records under one Date heading.

    Any suggestions?

    Tom

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

    Re: Reports Breaks (A2K SP-3)

    >> a listing of all records without DepositsDates followed by a listing of those records with Deposits Dates

    Wasn't that what you had first?

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

    Re: Reports Breaks (A2K SP-3)

    What I had first was a listing of all records without Deposit Dates sorted by RentPaidDate but not subtotaled by RentPaidPaidDate. All those records without DepositDate were subtotaled as a group, not by day. What they want are subtotals by RentPaidDate. (Not combined with those records with DepositsDates.

    This was followed by all records with a Deposit Date subtotaled by DepositDate. This part is working as they want.

    Tom

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

    Re: Reports Breaks (A2K SP-3)

    In the Sorting and Grouping window, enter the following expression in a blank row:

    =IsNull([DepositDate])

    Drag this row to the top, above the expression

    =IIf(IsNull([DepositDate]),[RentPaidDate],[DepositDate])

    To distinguish which date has been used for the subtotal, change the control source for Text89 to

    =IIf(IsNull([DepositDate]),"Rent Paid Date: " & [RentPaidDate],"Deposit Date: " & [DepositDate])

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

    Re: Reports Breaks (A2K SP-3)

    Many thanks for your sage advice.

    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
  •