Complicated query to traspose data and search records that approach a value

[planera63]

Ajax, could you suggest a tutorial on SQL Language to understand the use of Join ?

[CJ_London]

Ok. Now your code run !!!

and a bit faster too! - it was instant on my machine for 8k rows

Are you a software programmer ?

yes, self employed. My clients are from all types of industries and sizes from a few employees to multinationals.

Could you send me your email to ask you for other advice if it should happen ?

if you want free, you'll need to use the forum. If you have a budget then we can talk. Please PM me with your email to discuss further

Could you suggest a tutorial on SQL Language to understand the use of Join ?

I can't recommend any specific tutorial (there are a lot out there, just google 'sql tutorial'). Be aware there are many dialects (different RDBMS's can have elements/functionality that differ from each other in how they are written), so if using access ensure you are looking at Access SQL. However the basics are the same. I have used this for reference in the past https://www.w3schools.com/sql/

[planera63]

Thanks a lot. I am sorry but I work in a public company and it is already very difficult to entrust work to Italian companies; it is even more difficult, maybe impossible, to entrust work to foreign companies or sel employed.
My private email is planera63@gmail.com.

Bye and to the next

[accesstos]

Don't worry, there are many people in forums like this that are glad to learning by helping other people for free. So, you can ask our help for any issue that you face with your [interesting] project.
I addition, as a spear fisherman and free diver of Adriatic, I will give the best I can.

Cheers!