When I ran the union code I got an error saying: "Type mismatch in expression"
Also, I am a bit of a novice programmer when it comes to SQL, so your code is quite confusing, I am really grateful for all your help though, I'll spend a bit more time reading over it to understand it.
One more...
Hi all, I have found some similar posts along these lines but none with a field that was calculated in the same query. By the way, I am making a database on formula e, just so you understand what is going on here.
Here is the SQL code from the query:
SELECT
Max(race_results.r1) AS MaxOf_r1...