Hello, I've been trawling the web trying to find how to build the expression to rank how many machines an individual has sold by date and to assign points for the ranks - so he who sold the most 6points, 2nd 4 points, 3rd 3 points, 4th 2 points 5th 1 point.
This is how my query is set out
Thank you...
4 results in 0.0039 seconds.
-
How to rank and assign a value?
-
Ranking Query Is Too Large
I've got a ranking query that ranks the performance of teams in challenges.
The hierarchy of data is as follows:
teams have members
members have activities
activities have activitytypes
challenges have activitytypes
If I want to rank the performance all teams in a single challenge, this query works great:
...Code:SELECT t.teamID, t.teamName, scoring.challengeID, outerchallenge.name
-
Coding a Music Chart System?
Hello,
I just signed up on here, I found this site by googling.
A little bit about me, I've been building websites since I'm 14, now 23. I know about graphic design as well, my knowledge on the coding side is pretty basic tho, I'm slightly towards the artistic creative side, that's probably why my design skills are more advanced. :)
To my situation:
I'm planning to build a website that will... -
Use VBA to create required number of variables
How do,
I want to be able to make a certain number of variables depending on the number of data items i have to be used.
For example, i would need 3 variables defined when i have 3 numbers and 5 variables when i have 5 numbers.
Is there any way in the VBA that I can define variables with variables in the name (ie: Dim Number & x as Double within a For Next loop). I can do this with the text boxes on...
