Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2011
    Location
    New Jersey
    Posts
    2

    Trouble counting items in a report

    I created a database to keep track of families, dependents and financial information for an organization and am having trouble with something. I have a table which contains information for an applicant (head of household), co-applicant (spouse) and their basic information. I have a separate table for dependent information since there can be multiple dependent associated with an applicant. All tables are linked by a unique ID number given to each applicant. The problem I have is in my summary report. I am attempting to get a family size. The method I am trying to use is to have three text boxes. In the first box I ‘count’ the applicant (1). The second box ‘counts the co-applicant (1 or 0). In the third box I am attempting to ‘count’ the dependents. If I have more than one dependent in the table relating to the ID number, all the information in my report is duplicated by the number of dependents I have . Any assistance or ideas would be appreciated.

  2. #2
    boblarson is offline --------
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2011
    Posts
    1,272
    Instead of using it from a single query, you should have it either as a subreport (for the dependents) or using a DCount instead.

  3. #3
    Join Date
    Jun 2011
    Location
    New Jersey
    Posts
    2
    Thanks for the response Bob. I have all my data including dependents in as a subreport. I have multiple items in most subreports but the dependents subreport is the only one that duplicates my data, I will look into Dcount though.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. How display all 3 items on report without..
    By mr1sparkle in forum Access
    Replies: 1
    Last Post: 04-04-2011, 12:08 AM
  2. Report Help: counting and average
    By alliandrina in forum Reports
    Replies: 0
    Last Post: 03-08-2011, 01:24 PM
  3. Counting multiple items in a query
    By slaterino in forum Access
    Replies: 2
    Last Post: 10-14-2010, 08:21 AM
  4. Report trouble in Access 2000
    By blago in forum Reports
    Replies: 13
    Last Post: 09-16-2010, 07:12 AM
  5. Replies: 1
    Last Post: 11-11-2006, 08:00 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums