Recent content by GACat

I hav edone some tweaking on the coding and tried to add Groups for the TeamName but I keep getting an error that the "query is too complex" This is what I have now - but I am still not getting what I want - the list of particpants on each team that have the top 5 scores (from the possible...

Thanks - I think I am getting it.

I did a search and could not find anything that I think is like what I am trying to do (if possible). I am trying to have a query that will count all items in the "Name" field that are the same. The goal is to get a count of everyone with the same name - for each name. Is it possible? Thanks

Sorry - forgot to mention the version is 2007. I will try this and see if I can get it to work. Thanks

I am creating a report that shows members of a team - al completed in the details sections of the report I would like for each page of the report to look the same - ie same number of boxes, lines, etc. My issue is that most teams will have 7 members while some will have less.Is there any...

Good day: I have a subquery that I have created to try and get the top 5 scores for a team. Each team could have 7 members and they all could have the same score (for example 25). I developed this code following principles from this forum. SELECT tblParticipant.Division...

Great - Thank you!

I am trying to create a query that will show all members of a team. Each team can have up to 7 members Each member will have a score I need to sum the scores for each team, but include only the top 5 scores. Any ideas? Thanks

G'day: I have an database that is used to calculate and keep track of scores for competition events. tblPart has Participant Division (age) County TeamName Score 1 SO Score1 SO Score 2 When finalizing the scores for the event, I will have two reports, one for...