Recent content by stratocaster8

Question.... How do I assign a Game ID to each contest for every team since 1999? Do the games played have to be listed within the table in chronological order by date, or can I list every game by team by year (chronologically) and assign Game ID number that way? I'm just unsure how to...

When you say: Make a Team table with TeamID and TeamName. Make TeamID the Primary Key of the table. Ideally use a number format (Byte in this situation as you have less then 255 teams) for the TeamID. You can add other fields to this such as their home ground locations etc. Make a Locations...

Wow thank you for the detailed response. Since I am a very novice Access user, I'm going to address the first half of your reply before I even get into the rest. I appreciate your help for as long as you'd like to answer my questions. Thank you in advance. 1.Firstly I would encourage you to...

I know what I need can be done in Access, I just have no clue how to do it. My Access skills are very limited. Any help would be greatly, greatly appreciated. I have a table with every Yankee game's baseball data since 1999. It's about 15 columns of different types of data. One of the columns...