Results 1 to 12 of 12
  1. #1
    Herman Dickey is offline Novice
    Windows 7 64bit Access 2003
    Join Date
    Jun 2016
    Location
    Memphis, TN
    Posts
    29

    Need a Reference Please

    I am trying hard to be a big boy and "get it on my own". The report for work was received with rave reviews! However, the report lists each new record on a separate page rather than grouping them together under the headings.



    If I can read up on what to do, I have no problem following along. My Google search so far has been pointless, however.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Check your grouping sort,
    or see if there's a End of Page control on the report.

  3. #3
    Herman Dickey is offline Novice
    Windows 7 64bit Access 2003
    Join Date
    Jun 2016
    Location
    Memphis, TN
    Posts
    29
    Thank you!

  4. #4
    Herman Dickey is offline Novice
    Windows 7 64bit Access 2003
    Join Date
    Jun 2016
    Location
    Memphis, TN
    Posts
    29
    From what I can see, that doesn't appear to be helping. I am ready to kick the desk........geesh.

  5. #5
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716

  6. #6
    Herman Dickey is offline Novice
    Windows 7 64bit Access 2003
    Join Date
    Jun 2016
    Location
    Memphis, TN
    Posts
    29
    I know. It wasn't this complicated the last time I used Access. Geesh.

  7. #7
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Looking at database from other thread.

    There is a page break control in report detail section. This is forcing a new page after each record. If you don't want this then delete the control. PageBreak33 in the Properties Sheet dropdown. Frankly, I think report will look worse without it.

    The only grouping in report is on Client (which isn't really necessary).

    If you want grouping by OnsiteEvents/OnsiteSvcs/OffsiteAct/IJS - have to redesign report (build another one). Could use a UNION query to merge the 4 tables common type fields then apply report grouping. Example of UNION:

    SELECT ID, Client, EventDate AS RecDate, "OnsiteEvents" AS Cat FROM Records_OnsiteEvents
    UNION SELECT ID, Client, ServiceDate, "OnsiteSvcs" FROM Records_OnsiteSvcs
    UNION SELECT ID, Client, ActivityDate, "OffsiteAct" FROM Records_OffsiteAct
    UNION SELECT ID, Client, AppDate, "IJS" FROM Records_IJS;

    Pulling in fields that are not common to all tables is a little more complicated but then each group will show fields (empty) that don't apply to them.

    Alternatively, use 4 subreports.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  8. #8
    Herman Dickey is offline Novice
    Windows 7 64bit Access 2003
    Join Date
    Jun 2016
    Location
    Memphis, TN
    Posts
    29
    I did a separate report for independent activity and it worked perfectly. For the Case Managers' documentation purposes, however, I need to be able to show all employment-related information for each client.

    HEADING: Client Name, Program, Case Manager, Entry Date, Recertification Date (they have to have income growth within 60 days of entering the program, so I entered the formula to add 60 days to the entry date), and what field(s) they are interested in working in.

    DETAILS: Any services that we have provided onsite (resume building, application assistance, seminars/workshops, etc.), Offsite Activity (attending job fairs or seminars sponsored by other providers), Onsite Workshops (which WE present for our clients and monitor how many they attend for incentives), and finally companies that they applied to and the outcome of the application process.

    Each of these details is monitored by the Federal Government to ensure that we are providing clients with the assistance that they need to obtain income and become self-sufficient once their 6 months or 9 months of free services from our agency expire.

    This is what I need that one report to capture using all of the information presented.

  9. #9
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    You can include Caseload table in each subreport RecordSource. This will repeat client info under each category.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  10. #10
    Herman Dickey is offline Novice
    Windows 7 64bit Access 2003
    Join Date
    Jun 2016
    Location
    Memphis, TN
    Posts
    29
    When you say "include", you mean pull the information from multiple sources? This is where I get confused. In past experiences, I've not had to use a subreport.

  11. #11
    Herman Dickey is offline Novice
    Windows 7 64bit Access 2003
    Join Date
    Jun 2016
    Location
    Memphis, TN
    Posts
    29
    When you say "include", you mean pull the information from multiple sources? This is where I get confused. In past experiences, I've not had to use a subreport.

  12. #12
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Report RecordSource can be a query that includes multiple tables, usually with JOIN clause. Nothing extraordinary about this, basic functionality.

    Doesn't matter if the report is utilized as a subreport.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. What can ME. reference?
    By JamesDeckert in forum Forms
    Replies: 3
    Last Post: 12-04-2015, 02:59 PM
  2. Presumably a Reference issue
    By GraeagleBill in forum Access
    Replies: 16
    Last Post: 06-07-2014, 12:12 PM
  3. Broken reference
    By NOTLguy in forum Programming
    Replies: 5
    Last Post: 11-10-2012, 08:26 AM
  4. Missing Reference
    By teebumble in forum Access
    Replies: 17
    Last Post: 10-05-2011, 01:35 PM
  5. need help with reference..
    By dada in forum Programming
    Replies: 3
    Last Post: 09-17-2010, 06:07 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