Search results

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...

Hi there: I want to import a tabbed text file into Access. Problem is the text file is updated each day with a different name, and the user wants it automated. The fields would be the same each day. Basically I want to create a command button that would get the user to specify which text file...

Hello: I have my results showing now, and I have them looping through a table by row, using this: <% Do While Not rskg2.EOF %> and this at the end of the table: <% rskg2.MoveNext Loop %> This is great for one record per row. But I want to do 3 records per row, in 3 columns. Thanks for any help.

I have a from that returns two variables for each request. So if I request.form("quantity"), I get this - 11,20. Same with product size. I get. 18KG, 22KG I want to create an insert qry that puts 11 and 18KG in one record, and 20, 22KG in the next. Is this possible?

I have a form that will calculate a shipping cost based on a Canadian postal code. Right now, I have a text field where they can enter in the postal code. If the code is entered in without a space (ie T2V1R3 instead of T2V 1R3) it will not work, as it looks into the database for the rate. Is...

Can you use an OR in an IIF statement? For instance: IIf (Location = "27" or "18", TotalMgt, TotalMgt2). It doesn't appear to work whatever I try.