Results 1 to 2 of 2
  1. #1
    mam29 is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Sep 2018
    Posts
    1

    Access Report Help for Newbie

    Hi there-
    I'm an access newbie looking for help with a report. Can you please help? I love the Access program, I've looked at videos, bought the books but I'm stuck in the following situation:

    I'm helping my wife manage the school's second-grade soccer (football) league. I've made tables for: each player's information, each team ID, nickname, and color, and game schedule including a field assignment, and a home team and a visiting team. My issue is when I create a report based on the game schedule table, all I can get to show up is the team's ID. If I try to get the form to include the team's nickname or color, Access gets stuck. I don't even really know how to share the question properly, but I've attached two screenshots of the report in question. In the "print preview" version, I would like the team nickname to appear instead of the Team ID (AFC Bournemouth instead of BOU, for example). When I add the tbl_Teams which includes the team info I want for both teams, Access then only will show me one team's info, including the Team_ID.



    Any help greatly appreciated!
    Mark

    Click image for larger version. 

Name:	GameReport-with-TeamID-DesignView.JPG 
Views:	13 
Size:	168.9 KB 
ID:	35324Click image for larger version. 

Name:	GameReport-with-TeamID.JPG 
Views:	13 
Size:	57.6 KB 
ID:	35325Click image for larger version. 

Name:	GameReport-Tables.JPG 
Views:	13 
Size:	77.3 KB 
ID:	35326
    Info:
    Access 2013
    Windows 10
    8 Teams, with names based on English league
    75 players (give or take)

  2. #2
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,388
    The comboboxes' rowsource for the visit team and home team should be something like:
    SELECT TeamID, NickName from tblTeams;
    The bound column should be 1
    The data source should be teamId (which it appears to be already}
    The column count should be 2
    The columnWidths should be 0";1.5"

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

Similar Threads

  1. Newbie here, Report sorting
    By crunkdude in forum Reports
    Replies: 4
    Last Post: 05-26-2017, 05:41 AM
  2. Replies: 1
    Last Post: 09-08-2014, 06:08 AM
  3. Newbie Report Help!
    By Vi-Scan in forum Reports
    Replies: 2
    Last Post: 05-02-2013, 04:43 PM
  4. Newbie: Print Analytical Report
    By frosty in forum Access
    Replies: 5
    Last Post: 09-20-2011, 02:12 AM
  5. Newbie problem with report!
    By BillyAckers in forum Database Design
    Replies: 2
    Last Post: 03-23-2011, 02:27 AM

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