automatically assign value

S

S

My data includes 3 scores, then I have a query to add those scores together.

Data
Entry # Performane Score 1 Performance Score 2 Performance Score 3

Query
Total Performance:[Performance Score 1] + [Performance Score 2] +
[Performance Score 3]

My Problem is now that I have the total performance score I need it to
assign a medal award.

For example:

Total Performance = 275 (3 scores added - 92, 91, 93)

Say If a gold medal is between the scores 270 and 281 how can I make it
automatically fill in the award earned in a column next to the total
performance score.

I have several medal standings:

Bronze = 210-224
High Bronze = 225-239
Silver = 240-254
High Silver = 255-269
Gold = 270-281
Supreme Gold = 282-300

Any help would be greatly appreciated
 
K

KARL DEWEY

Put your medal standing in a table like this --
Low High Medal
0 209 Honorable Mention
210 224 Bronze
225 239 HighBronze
240 254 Silver
255 269 HighSilver
270 281 Gold
282 300 SupremeGold
Then use the medal standing in a second query that has the first query. Use
Between [Medal Standings].[Low] AND [Medal Standings].[High] as criteria on
the Total Performance field. Include Medal field in output grid.

Similar to this query for mileage rates
SELECT Travel.Name, Travel.Mileage, [RateTable-Mileage].Rate
FROM Travel, [RateTable-Mileage]
WHERE (((Travel.Mileage) Between [MinMiles] And [MaxMiles]));
 
S

S

WORKED LIKE A CHARM - THANKS!!!

KARL DEWEY said:
Put your medal standing in a table like this --
Low High Medal
0 209 Honorable Mention
210 224 Bronze
225 239 HighBronze
240 254 Silver
255 269 HighSilver
270 281 Gold
282 300 SupremeGold
Then use the medal standing in a second query that has the first query. Use
Between [Medal Standings].[Low] AND [Medal Standings].[High] as criteria on
the Total Performance field. Include Medal field in output grid.

Similar to this query for mileage rates
SELECT Travel.Name, Travel.Mileage, [RateTable-Mileage].Rate
FROM Travel, [RateTable-Mileage]
WHERE (((Travel.Mileage) Between [MinMiles] And [MaxMiles]));


--
KARL DEWEY
Build a little - Test a little


S said:
My data includes 3 scores, then I have a query to add those scores together.

Data
Entry # Performane Score 1 Performance Score 2 Performance Score 3

Query
Total Performance:[Performance Score 1] + [Performance Score 2] +
[Performance Score 3]

My Problem is now that I have the total performance score I need it to
assign a medal award.

For example:

Total Performance = 275 (3 scores added - 92, 91, 93)

Say If a gold medal is between the scores 270 and 281 how can I make it
automatically fill in the award earned in a column next to the total
performance score.

I have several medal standings:

Bronze = 210-224
High Bronze = 225-239
Silver = 240-254
High Silver = 255-269
Gold = 270-281
Supreme Gold = 282-300

Any help would be greatly appreciated
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top