Recent content by mugman17

I am having trouble with a query that should be simple. I have these fields (among others) Season, PlayerID, PassingAttempts, TeamID. I want it to show the highest attempts broken down for each season. I tried to use MAX with Passing Attempts which works, but when I add Season to the query I get...

Basically the query works but its giving me an error when I trying to access the coach names. If I try this I get an error message: <%=rsCoach.Fields.Item("tblCoaches_1.CoachName").value %>

I recently converted a website that had an Access backend to SQL server. Had some queries that didn't work anymore (Mostly IIF to CASE changes). This one does not work at all anymore. Something to do with have 3 of the same table opened at once I would think. strSQL = "SELECT...

Thanks Gizmo, that worked perfectly.

I have a form with some basic contact information. My client wants a button that copies some of that information, like name, phone number and e-mail address, and then it can be pasted into either an e-mail or an IM. Any ideas?

I have them so they are split up per team. But now I am having players showing up in the team listing even if they dont play on that team, if they have the same yard totals. So if two guys had 4500 yards passing in 2009, one was with Team 18 and the other was with Team 51. They each appear as...

Still having issues with it. If two players have the same yards in the same year (which happened believe it or not), it puts the totals for that player into both teams. Its because of the joining of the passing yards in the TopPassing query, same goes for the other queries.

That worked! Thanks Bob. I really appreciate your help.

That gives me the totals and breaks it down by year, but I still need to have a PlayerID attached to each one. When I try that, everything gets messed up.

That appears to be giving me the highest number and the season it was accomplished, but its not breaking it down per season. What I need is somewhat like this below: Season - 2009; PlayerID - 1; PassingYards - 3000 Season - 2008; PlayerID - 1; PassingYards - 3400 etc. This works well: SELECT...

Yes, sorry, I need the player per season with the highest total for each.

Hi there: I have a table thats set up like this: PlayerID Season TeamID PassingYards RushingYards ReceivingYards I would like the query to find the highest number in Passing, Rushing and Receiving per season. Do I need to do each one in a seperate query? Thanks.

Hi there: I would like to duplicate a record. However, I dont want everything. There are a few fields that I would like left blank in the new record. So is there a way to copy certain fields of a record? Obviously, the wizard just allows me to copy over the whole record. Thanks.

Its MS Access 2002 SP3. The database is not split as only 2-3 users are on it concurrently.

I have created a form that runs with several different tabs. My client runs it on a network. For some strange reason, the color of the tabbed area has turned white when on the network. When they send it back to me to fix, it has reverted to its original blue color. Any ideas of what might be...