Recent content by coach.32

I have two queries; the first is: #SELECT Max(tblWinnersOnlyAllAges.P1) AS MaxFor, tblWinnersOnlyAllAges.Team, tblWinnersOnlyAllAges.Age FROM tblWinnersOnlyAllAges GROUP BY tblWinnersOnlyAllAges.Team, tblWinnersOnlyAllAges.Age ORDER BY tblWinnersOnlyAllAges.Team, tblWinnersOnlyAllAges.Age;# The...

I have read numerous posts on how this is achieved, but I cannot apply my data to any of the solutions to get my results. I have a number of results Win, Loss or Draw from our local football League. I am trying to count the most wins in succession by any one team. The table is designed as the...

I have a table that shows the scores (Australian Rules Football) of a whole lot of games played over the Seasons. An example of that data is: R Age Year Team G1 B1 P1 Team V G2 B2 P2 1 15 1980 Beaconsfield 10 10 70 Berwick 25 12 162 2 15 1990...

I have a query that has summed the Aggregate total for each round (R) for each year. I then created a crosstab query that showed which was the maximum total for each round. In the sample data it showed R1 was 99 points and Round 2 was 94 points. The actual table contains 16 rounds over 30 years...

I have a form with a Date txtbox on it. Is it at all possible to make the txtbox Flash everyweek when it is 'Tuesday'. The reason for this is just a reminder that certain functions have to be performed prior to pressing other access buttons on the menu. Thank-you for any advice.

I have a report that lists 10 Clubs with Win/Loss details next to each one. I want to shade only the top four Clubs and their details. Is this at all possible? Thank you for any assistance you can offer.

Hi James I have uploaded a sample as the DB was is very big, but the data contained in the upload is enough. I think the reason for the second query was so that when I found what the Maximum scores were I then needed to list the entire row for each one. The perfect example of what my problem is...

I have a database that collates the scores from our local Aussie Rules football league. I needed to obtain the maximum score kicked for each particular Round. I was advised from this Forum to have two select queries as below: SELECT Max(AusFootBall.P) AS MaxOfP, AusFootBall.Rd FROM AusFootBall...

Thank-you JDraw, that worked a treat. I then decided that I needed to show the Highest 'P' for each round for each of the 3 divisions that we have (1, 2, 3). When I did this, I found that if the highest score in Division 3 was 37 for example, then the result for Division 1 would show it's...

I have a database that contain over 10,000 records from football (Australian Rules) scores. An example of the data is as follows: Rd Dn Team G B P Team2 Year 1 1 Berwick 15 10 100 Noble Park 1998 1 1 Hallam 12 19 81 Geelong 2010 2 1 Cobram 14...

I have a form that has a textbox which shows today's date. I would like to have another text box that shows only the Monday prior to the current date. Is this at all possible and if so how? Thank-you in advance for any help you may offer.

I need a report that shows data in the following format 0-7 8-14 15-21 22-28 29-60 61-90 >90 1743 6 5 15 29 12 13 8 1744 7 3 18 45 15 12 9 I have a query for each time period (eg: 0-7...

I have a query that contains TeamId Age Period 1743 69 61-90 1743 15 14-21 1747 7 0-7 1743 19 14-21 1744 32 29-60 I have created a Union query based on the above main query, which lists the number of occurrences for each Team Id...

I have a table that I need to eliminate certain duplicates from. An example of the data is: Account - Team 14983 - 1743 14983 - 38466 15621 - 38466 15000 - 38466 19816 - 1743 15621 - 38466 My problem is that I need to remove duplicates but in the same instance I need to keep a...

Thank-you for your advice. I have tried the JOIN command but I am not having much luck. Using my SQL could you please give me an example of how to word this? Thank-you for your patience.