Recent content by Jossy

Having worked with VBA for a few months I've now set myself the task of cleaning up a lot of messy code I wrote a long time ago. All my subs and functions are in one module and I want to structure them more neatly. This means separating them out into groups, putting them in different modules and...

Great, thanks again CJ.

As ever CJ - thanks. Will run 1-2 times per day depending on location of matches, e.g. Europe, US, Asia. The dupes were me not joining correctly - fixed this now. The hard coded values were necessary as otherwise I'd have had to have all the non-Djokovic player matches in there. So values...

Hi CJ. Firstly - thank you so much for building this - it must have taken a while. I really do appreciate it. I've also learnt loads from looking at the table and query structures and reading the SQL, e.g. aliases, Nz functions to name a couple. Have a few questions if you don't mind? 1...

Thanks CJ. Will have a look at doing it this way.

Really appreciate this CJ, I really do. I've been working on the VBA this afternoon and managed to find a useful post from "asc" about half way down this page: https://forum.punterslounge.com/topic/71276-elo-access-function/page/2/ Interestingly his data looks like it is formatted in the same...

Ok thanks. Will work out the best way to do this.

Thanks CJ - really do appreciate your help. The data is normalised - it's a well structured third party product. The Excel is a copy and paste from a query of a few tables - the structure of which is very similar to yours :-) So I need to go the VBA route you reckon and build a table...? Okay...

Thanks for picking up the mantle CJ. There will be two main outputs needed: 1. The ability to see the latest ELO rating for a given player. In this case it wouldn't be necessary to calculate all rows for all players. However, the way the calculation works it will probably be close to all...

Completely understand and thanks for your help so far. Attached the file to this post.

Hello again Isladogs. Mind if I take you up on that offer? This isn't related to the serialize function but is completely in line with the original post I made. Here goes... so I've used serialize to create a rank field for my data and I've now been looking at how I use this lookup a previous...

Managed to figure this out using ISNULL: SELECT ELO_ranked_lookup_atp_small.Rank, ELO_ranked_lookup_atp_small.ID1, IIf(ISNULL((SELECT TOP 1, Dupe.ID2 FROM ELO_ranked_lookup_atp_small as Dupe WHERE Dupe.ID1 = ELO_ranked_lookup_atp_small.ID1 AND Dupe.Rank <...

Will do. Thanks

Started a new thread on something slightly different but related. Do I just put the link to the new thread here?

Hi. I have a query I've built that produces three fields: Rank - 1, 2, 3 4 etc (sorted in descending order) ID1 - an identifier of a person, with duplicates ID2 - an identifer of a second person, with duplicates From this query I want to write a second query that selects both the first two...