Search results

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.

I have the following code for one of my Crosstab queries. My question relates to the 'PIVOT' part of the code. Am I able to include another PIVOT argument that will show all the rows? Do I add 'AND to the argument? I need to show all rows and columns. Thank you for any assistance you can offer...

I have created a Query (with Totals) that counts various criteria. I need the query result to show zeros, so that all figures can be transposed correctly to a report. This report needs to go out daily and the recipents need to see where the zero's are. I have used the following formula, but...

I have created an Iif statement on my text box in a report. =IIf([Acty_Priority]="3-Medium" And [Acty_Cmplxty]="Low",1,0) The 2 fields are the headings in a query. Why do I receive a #Name? error when I view the report? The name of the query is "Stats". Thank you in advance for any help. The...

I have created a union query that counts the number of records that meet different criteria. The query produces just 3 columns of data - Count - Priority - Complxty. Is it possible to do an IF statement on a report to extract one of the pieces of criteria from the union query. eg: If Priority =...

I have created a Union Query that counts certain criteria from a Table. I have found that if the criteria for one of the arguments in the Union Query is zero then that doesn't show up in Datasheet view. Is it possible to still show the zero values as I need to put all the selections into a...