Need Accepted/Denied based on Number Ranking

[WillYum]

Hi! Okay,okay, I need help so here is my situation.

I have 2 tables.

Entries (1) ------ (many) Judging

Now each entry has 3 judging entries where they were ranked on a scale of 1 to 5... I can calculate the total score easy.

Now, I want a control (text box, combo box, whatever) to update and display whether an entry was Accepted (above 8), Denied (8 and below) or Disqualified (0). I have a query already calculating their rank [Ranking].

If it were a single form, I could easily do this in the OnCurrent of the form, however because it is continous (each entrant can have up to 3 entries) I guess I need to use a query (or some form of advanced code that I don't get! Yeak)

Help please!

- William ~^~ ~^~

~ W . I . L . L . Y . U . M ~
wOrLd WiDe WhAt?

 

[grnzbra]

How about a text box with the datasource set as:

=IIf(Score>8,"Accepted",IIf(Score>0,"Denied","Disqualified))

 

[WillYum]

Thanks, a few more nests and that worked beautifully... However I wonder if it is possible to do that in a query somehow?

Just curious.

Thank you!

- William ~^~ ~^~

~ W . I . L . L . Y . U . M ~
wOrLd WiDe WhAt?

 

[PHV]

The IIf function is perfectly legal in queries.

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244