competition DB

[Jingels]

Hello,

i have a competition DB. But i want to calculate the winner of the game. you get points the highest one wins but if there is a draw then the time has to be checked as well. how can I do that.

thanks

 

[arnelgp]

if there is a Date/Time field on your table, then you can compare tied ones against this field.

 

[Jingels]

Yes there is a Date/time Field. but how can a compare between the two records.

 

[plog]

Can you post sample data from your table? I will need 2 sets:

A. Starting sample data that is in your tables. Include table/field names and enough data to cover all cases.

B. Expected results based on the data you provide in A. Show me what you expect to be returned as the final output using the sample data you initially provide.

 

[Jingels]

View attachment test results.accdb

this is a sample database.
i want in my report for each level placed from 1st to the last based on the score. but if there is a tie there has to be looked to the time and fastes time wins.

thanks

 

[arnelgp]

just sort your query by [score],[time] ascending

 

[plog]

That was A. Now please post B--expected results. Based on the data in that database show me what you expect as output.

 

[arnelgp]

ive made some function for the ranking, it is called in your query. also made changes to the query to sort correctly, by score (descending) and time (ascending).

 

[Jingels]

@Plog, Based on the score i want a raking and if there is a tie the fastes time wins.

@arnelgp, the attached file i can not open it.

 

[arnelgp]

how come, im attaching it again.

 

[arnelgp]

try both accde or mdb.

 

[Jingels]

i get attachment.php

 

[arnelgp]

use firefox or chrome.