Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Dchall_San_Antonio

  • Rank
  • Birthday 10/30/1951
  1. Maybe I complicated the question too much. Let's say we're playing baseball. Bobby Smith got 3 hits in his first game, 0 hits in the second, and 3 hits in his third game. I have one record for each game where I keep track of statistics. Hits has its own field in the record. I want another field that totals his hits. What single calculation do I use to total the hits? I can get the number by making all his records appear and using the summary function, but in this case I do not want all his records to appear. I want just the total hits to appear.
  2. I'm building a db of sports statistics (at least I'm trying to). I have a layout which shows the players' performances together for each match. I have fields which summarize the data by match or by individual player. How do I set up one field which summarizes, say, all of the Serving performances for one player without pulling all the records for that one player? Eventually I want to make a layout that shows an entire team's accumulated player performance. So instead of showing performance of players 1-12 for each game I want to show the sum performance for players 1-12 for all the games.
  3. Hello, I'm back with more issues. At this point I'm tuning it up, though. Still I am missing a fundamental link so this question still goes into the relational db forum. 1. In the TeamRoster db and layout, I created a PlayerID number consisting of the concatenation of the player's jersey number and team name. It is a text field. Now when I search on that field for "2 - Blue", rather than getting only jersey number 2 on the blue team, I get all the jersey numbers from the blue team that contain a 2. Also when I sort the Player ID field, it sorts like a text field instead of a numbe
  4. How do you do that? I can download it and use it but can't see how it's done.
  5. Thanks again. That short list, and a lot of fiddling around, got me going. This is working out great!
  6. Players can switch teams mid season. There are three teams, A, B, and C, from the same grade. The A team has the most skilled/talented/experienced players. C has the least. B is in the middle. Teams are selected originally so that they all might have a winning season. Thus the A team has most of the good players but some of the less talented or inexperienced players are assigned to A. Team C has most of the untalented and inexperienced players with a couple of relatively skilled players. B is in the middle with a mix of some very good and some who show a lot of promise. If a player on
  7. Thank you for your patience. I have been using Excel since it came out on the Mac in the 80's and consider myself to be far beyond the average user in spreadsheet skills. Every time I see a problem I can see the end result as a spreadsheet. Interestingly I cannot envision a db design to save my life. 100% mental block. Thanks for the previous verification of how you created the second db for the team roster. I've done the same - pretty simple once you get over the initial mental block. I am absolutely thinking like a spreadsheet! Forgive me for one last minute for slipping in
  8. mfero, Thanks. Couple more questions... 1. I see you have added the Player Roster, Teams, and the Player match data db's and related them to the PerformanceData and Matches db's. How did you pull the fields out of one db and put them in another? Please tell me it was by the drag and drop method and not by the brute force and ignorance method (the one I would have used). I spent considerable time yesterday trying to figure out if that could be done easily. Or did you duplicate the db and then delete the inappropriate fields from each one? 2. I'm still not sure how to make t
  9. Every now and then I need to stop by here and show my ignorance of basic database workings. One of my hobbies is statistics. Now that my daughter is playing volleyball, I thought I'd set up a place to track performance. My comfort zone is Excel and that has worked very well, but I know spreadsheets are fraught with peril. As I started implementing my spreadsheet in FMP I eventually realized that I goofed in the basic set up. I put all the data values into the "personnel" database. That works great for 1 event, but I obviously will need to put data in for many matches. Each match h
  10. I can see that you did it but how do I see how you did it? Or is this only something you can do with the later version of FMP? EDIT: I think this is a rhetorical question...further research is being conducted...
  11. This task has been overcome by events. The boss came in today and told my my services were no longer needed.
  12. Thank you for your replies. That's what I feared. Didn't know about that. I'll try that with the columns I need and see what happens. Part of the problem is about every other month the client changes what she wants us to send. Which I have done many times. I was hoping to shortcut that process. The requirement is to send an Excel spreadsheet. Prior to this a .pdf file was acceptable. This spreadsheet requirement is a trade off. We only send in one form and they create four forms. Before we were creating all four forms. We like this idea but I will not co
  13. In the table view can I copy a column of values and paste them into Excel? ...or do I have to export the entire table to Excel and copy/paste columns from spreadsheet to spreadsheet?
  14. Which brings us right back around to the OP's original question. I did use the export function for about a week when I first got FMP but found it to be intolerably cumbersome. With Microsoft Office I could print several merge docs from the same data resorted different ways (in real time) in about as long as it took to write this paragraph. With the FMP export process in the way, you can't do that. FMP needs to get with Microsoft and work this out to a seamless integration. The industry I work with will never stray from MS Office products. Unfortunately that limits the ability of a
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.