Re: Help with Query Calculation

Tech-Archive recommends: Fix windows errors by optimizing your registry

Without a bit more description of your underlying data structure, and
possibly a look at the SQL of whatever query you are now using, it will be a
little tough to come up with suggestions.

You may want to take a look at Access HELP on the DCount() function. You
might be able to use this (instead of an IIF() function) to calculate how
many entrants you have in a category.


Regards

Jeff Boyce
Microsoft Office/Access MVP

"DN" <DN@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:BDF62C05-4E77-4699-AF74-845B27A981DD@xxxxxxxxxxxxxxxx
Looks like you do understand the challenge. Or, at least it is a
challenge
to me. Is there a way to do this with an IIf statement? I do want to
throw
out (ignore) zero or negative points.



"Jeff Boyce" wrote:

I may not be understanding, but it sounds like you are saying that the
number of points for the 1st place finisher is = the number of entries in
the class (with a maximum of 6).

If that works, then one way to look at the 2nd place finisher's score is
the
difference between 1st and 2nd place (i.e., 1), subtracted from the
number
of entrants (with a maximum ...).

It might be a bit of a brute force approach, but the values for finishers
1 - 6 could all be calculated that same way. You'd just throw out any
zero
or negative points (because this would mean there weren't that many
entrants).

Or have I totally missed your situation?

Regards

Jeff Boyce
Microsoft Office/Access MVP
Microsoft IT Academy Program Mentor

"DN" <DN@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:3455FEDA-4872-4BA5-977E-E601F1814538@xxxxxxxxxxxxxxxx
I am asking for assistance in constructing a query calculation to assign
points to how a horse is placed in a class at a show.

6 places are tied if there are 6 or more entries in the class. Only
the
1st-6th would get points. The spread would look like this:
1st-6 points
2nd-5 points
3rd-4 points
4th-3 points
5th-2 points
6th-1 point

If there were only 5 entries in the class, the spread would look like
this
1st-5 points
2nd-4 points
3rd-3 points
4th 2 points
5th-1 point

The spread would continue with 4 entries in the class or 3 in the class
or
2
in the class until there may be only 1 in the class where that entry
would
only get 1 point.

Any assistance in getting this started would be appreciated.
Debbie





.

Relevant Pages

  • Re: Help with Query Calculation
    ... Microsoft Office/Access MVP ... places are tied if there are 6 or more entries in the class. ... If there were only 5 entries in the class, the spread would look like this ...
    (microsoft.public.access.queries)
  • Re: Help Writing Criteria For Report/Query
    ... I want the report to pull items that are due. ... "Jeff Boyce" wrote: ... report that shows today's entries, and in another report that shows entries ... Microsoft Office/Access MVP ...
    (microsoft.public.access.reports)
  • Re: Help with Query Calculation
    ... I might first write a query that calculates all ... Microsoft Office/Access MVP ... "Jeff Boyce" wrote: ... places are tied if there are 6 or more entries in the class. ...
    (microsoft.public.access.queries)
  • Re: Multiple Record Inputs with one Form
    ... For intCount = 1 To Me! ... the entries from the form inputed. ... "Jeff Boyce" wrote: ... database will let you do. ...
    (microsoft.public.access.formscoding)
  • Re: Help with Query Calculation
    ... I did take a look at the DCount function and I am ... Here is the query I am using to calculate on ... "Jeff Boyce" wrote: ... places are tied if there are 6 or more entries in the class. ...
    (microsoft.public.access.queries)