If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
count related records only
I have a report that shows detail only from a head of household query. The
report also has a subreport that lists the related records (family members) from another query. I need the detail section of the main report to count the records that are displayed in the subreport. I tried using the dcount function, but I don't know how to write the criteria so that it counts only the related records. I am counting a primary key field that is named ID. TIA. -- Deb H |
#2
|
|||
|
|||
count related records only
You can place the Count in the report footer of the subreport. Then you can
add a control in the main report with a control source like: =srptCtlName.Report!txtCount -- Duane Hookom MS Access MVP -- "Deb H" wrote in message news I have a report that shows detail only from a head of household query. The report also has a subreport that lists the related records (family members) from another query. I need the detail section of the main report to count the records that are displayed in the subreport. I tried using the dcount function, but I don't know how to write the criteria so that it counts only the related records. I am counting a primary key field that is named ID. TIA. -- Deb H |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Have a numeric field, need to count records with specific entry. | Jose--UBOC | Setting Up & Running Reports | 1 | August 24th, 2005 09:18 PM |
How do I count, with criteria, a group of records on a report? | DanVB | Setting Up & Running Reports | 1 | April 8th, 2005 12:38 AM |
Access can't count? Grouping records by 100's | code | Setting Up & Running Reports | 5 | January 28th, 2005 10:21 AM |
count records based on date range | keith0628 | General Discussion | 1 | October 26th, 2004 07:51 PM |
Which function to use to count the records satisfying two criteria? | Max | Worksheet Functions | 0 | November 21st, 2003 07:59 AM |