Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Location
    California
    Posts
    502

    Unanswered: Count [TblName.Detailrecs] of main report in sub report

    I have one txtfield in the detail section of the main report that I would link to total in the subReport.

    I have a sub report based on a calculations query.

    I need to =count(txtfield) in the main report and place that in the report footer of the subReport.

    I've found this is klind of tricky!

    This is what I've tried but it fails.

    In the Control Source =Count(tblMain.xtxField)

    Thanks . . . Rick

  2. #2
    Join Date
    Mar 2004
    Location
    California
    Posts
    502

    Foud it!

    In my original calculation query I place a field with a count on it.

    CountName:txtField
    Count

    Then in my subReport I just placed CountName field in the subreport.

    Whalla!

    Correct Count.

    Kewl!

Posting Permissions

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