Recent content by jonsimons

Thanks Jon K!!!! That works great! :D :D :D God the world isan't such a bad place :)

thanks for that solution.. i think ive also found another way round my problem.. i could just link the table to an excel sheet, i would carry out all the calculations in excel and then bring the data back to access.. volla :D but.. would this work? :rolleyes:

yeh.. I think the best way to work out the grid positions for the final is to give a driver so many points for finishing in a certain position... For example... 10 points for 1st, 9 points for a 2nd, 8 points for a 3rd, 7 points for 4th etc.. Then to work out the grid position for the final, I...

umm.. into what categories?

Yeh sorry.. im quite poor at explaining things :rolleyes: There are three car races... Heat 1, Heat 2 and the Final. The position column.. 1,2,3 etc is what position each driver came in that race.. Every driver has their own number.. From that query.. you will see that in heat 1, driver...

If I add the two fields together then that will just add their numbers together rather than their positions..

Pleaaasee.. Need help with query.. Hi, I have this query, (you can see a picture off it in the attached file).. I want to work out the position for the final by using the positions for the first two heats. This is how it works: Say if a number came first in heat 1, and first in heat 2 then...