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
Info:
Access 2013
Windows 10
8 Teams, with names based on English league
75 players (give or take)