Prev: how can i format a date that uses "1st" or "2nd" or "3rd" or 4th".
Next: Problem with printing multiple copies of a report
From: h20vrrq on 6 Apr 2010 06:24
Perfect, thank you very much. Worked exactly as I needed it to.

"Duane Hookom" wrote:

> Since this is for a report, you don't have to do anything in your query other
> than provide the required fields and records.
>
> Group and sort your report as needed:
> - Competition
> - Category
> - MFJ
> - Your scoring expression
> Make sure you have at least a group header on MFJ. Add a text box to the
> detail section:
> Name: txtCount
> Control Source: =1
> Running Sum: Over Group
> Visible: (it's up to you)
> Then add one line of code in the On Format event of the detail section. This
> is actually code, not the property. The On Format property should be:
> On Format: [Event Procedure]
>
> Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
> Cancel = Me.txtCount > 3
> End Sub
>
> This will cancel the display of any more than 3 records.
> --
> Duane Hookom
> Microsoft Access MVP
>
>
> "h20vrrq" wrote:
>
> > Hi, I know this question has been asked before and I have looked at some of
> > the posts but I just can seem to work this one out, so I hope someone can
> > help.
> >
> > I am running a competition where we have 100 competitors taking part in
> > different categories within different versions of the same competition.
> > Competitor A Competition 1 Category z M
> > Competitor B Competition 1 Category y F
> > Competitor C Competition 2 Category z F
> > Competitor D Competition 2 Category y J
> > And so on for 100 competitors, 4 different competitions and 7 different
> > cateogries.
> >
> > We run the same competition several times year, but with different Event
> > names.
> >
> > So for each competitor I will have the following information: -
> > Event,
> > Forename,
> > Surname,
> > Club,
> > MFJ, (male, female or junior)
> > Competition,
> > Category,
> > FinalScore,
> > Checkpoints,
> > Bonus
> >
> > All of this information is stored in one table called 'Competitors'. One
> > record is stored per competitor as that is all that is needed. I'm currently
> > using a query called 'q_results' to filter the records just down to the Event
> > I want. So the query has all of the records I need and nothing more.
> >
> > What I need to do is write a report that shows me the top 3 competitors
> > grouped by
> > Competition , Category, MFJ
> > and for each of the above I need to show
> > Forename,
> > Surname,
> > Club,
> > MFJ, (male, female or junior)
> > Competition,
> > Category,
> > FinalScore,
> > Checkpoints,
> > Bonus
> >
> > The top 3 have to be displayed in the following order: -
> > FinalScore,
> > Checkpoints
> > Bonus
> >
> > With the highest FinalScore in first and ties decided on highest Checkpoints
> > followed by highest Bonus.
> >
> > I am using Access 2003 and my skill level is not that high, I can write
> > simple queries/reports but nothing too advanced.
> >
> > Any help is greatly appreciated.
> > Thanks,
> >
 | 
Pages: 1
Prev: how can i format a date that uses "1st" or "2nd" or "3rd" or 4th".
Next: Problem with printing multiple copies of a report