Recent content by Jay_1982

Wow indeed! Your solution was both elegant and absolutely spot on!!! Appreciate how how you've taken the time to explain what each of the queries does too, that's a huge help to a novice such as myself. Thank you so much @plog !

Hey @plog , attached is some sample dataset and the expected output.

Morning gurus I'm stumped and need some help with a query join. I have a table called "Role_Transactions" (its from SAP) and for each "Role", it has multiple "TCode_From" and "TCode_To" values. Example below; I need to match all the "TCodes" from table "Transactions" to the "TCode_From" and...

TJPoorman you absolute champion! :D It worked like a charm! Cheers Jay

G'day folks! I'm not too bad when it comes to Access, but whenever I've gotten stuck I've always been able to find solutions to my problems on this site. :) However I've been searching far and wide for a solution to my current problem, but due to having absolutely no VBA knowledge I'm stuck...