Recent content by ChadW

Sorry.... and the use for the function is to return the stableford score for each hole.

Hi thanks for your reply. I plan to call this function for each score(on-leave) entered in the GUI scorecard for each player. I need to pass four parameters into the function Handicap(iHcap), Par(iPar), Stroke index(iStrInd) and the gross score(iScore). My trouble is that I'm a bit unsure...

I am trying to write a function which calculates the stableford score for a golfers round. Unfortunately, I am quite new to access and my coding experience is with Progress Open Edge. I have attached the code I have attempted to write below, any help would be greatly appreciated. Private...

Hi, I am new to access and have created a database to administer a small golf society. Till now I have been posting out details of results etc to members, but would now like to make the data available on-line. I have purchased some web space, but unsure of how to go about publishing the data...

Leigh you are a star, works perfect. Thank you very much:D Chad

Yes, tried it for the top 3 results on a sample data base I have. If the 4th best result had the same value as the 3rd best this was calculated in the points total. ie. 40,40,39,39,38, the total should be 119 (For top 3) but is returning 158.

Thanks for the code, it worked great. However, the same problem still remains addressed earlier. Is there no way around this. My Scores table as you thought does have ScoreID (Autonumber) as its primary key.

So there is no way really to apply this query in access? Just a case of exporting the data to excel and using the LARGE function.:(

Thanks for your help dallr, the code is working great :D Just one thing, when requesting the top 'n' points if there are duplicate points values then the query also accumulates these values. ie. if requesting the top 5 points from a member and his scores are 40,40,39,38,38,38,36, Then his...

I have tried to use this query on a single members scores but when trying to total the top 12 scores, the total of all that members scores are returned.....help:( Code: SELECT TOP 3 Scores.MemberID, SUM(Scores.Points) AS TOTAL FROM Scores WHERE (((Scores.MemberID)=1)) SORT BY...

Thanks again, you were correct about the output. The query calculates each members full totals and then lists the top twelve members:confused::confused:.

Thanks for your reply, I have tried the code but returns an error message: Syntax Error (Missing operator). I have attached the code below: SELECT TOP 12 Scores.MemberID, Sum(Scores.Points) AS total FROM Scores GROUP BY Scores.MemberID SORT BY Sum(Scores.Points) As Total DESC;

I have recently begun using access to develop a small golf application to help a golf society I run. I have coding experience but it is with Progress. It is basically complete, however I have one hurdle I cant seem to get my head around:confused:: I need to create a query that I can output to...