Counting and Calculating List of Dates

  • Thread starter Thread starter dmasch
  • Start date Start date
D

dmasch

I have a database that has several "games". Each game has a group of players
and the date they started the game. I want to calculate the time (in weeks)
between the date that the first player joined the game to the date when 25%
of the players joined, 50% and 90%. Each game has a different number of
players and there is not a field that gives a number or rank to when the
player joined the game, just the date. How can I query the database to show:
Game 1: Time between 1st player to 25% of all players, 50%, 90%
Game 2: Same as above...
Hope this makes sense. I appreciate any help that can be offered. Cheers!
 
can you post your table structure so we know the table names and the
field names so we can build a query

also is there a field that notes how many players are needed for a
game or are you only looking to use this query for historical
purposes
ie after the game has commenced and no more players can join if this
is so and there is no field noting how many players are alowd is there
a way to detremine the point no more players can join from the
database.

Regards
Kelvan
 
Table Name: VACCTR
Field Names: GameName (ID of game), PlayerJoin (Date of player joining game)

That is all I really have to work with. It is a historical query after the
game is complete and all the PlayerJoin dates are entered. So basically I am
thinking of having some type of Count query to count the numer of Players
joined in the game. Next they have to be order or ranked to figure our the
player that represents the 25%, 50% and 90% of all players and the Date
difference between their join date and the first players join date. Sorry, I
know this is kind of weird. Thanks
 
your table structure makes it a little hard your table structure
should be

tblgame
gameid
gamename

tblplayers
playerid
gameid
playerjoin

but regardless i couldnt come up with a solution that worked because
of the possibility that there could be an odd number of players and
many players starting on the same date.

to say what is the the 25th% player out of 5 players is technically
impossible as 1/4 of 5 is 1.25

sorry i cannot be of help

Regards
Kelvan
 
Back
Top