Search results

So Sorry Will go the whole hog and tell you why i've done it via a form. Bascially I need to rank players for their finishing places in a tournament (Golf), so for example one player wins (P1) then three placers come 2nd (P2) then next best score comes 5th (P5) as 4 players are before him and...

i am sure there may be an easy way of achieving this but after 2 days trying...it's beyond me ! I have a mutli record continuous subform with some calcualtions behind some of the txt boxs, therefore they cannot be linked back to table fields. i want to extract the results of this subform into...

I did consider VBA Matt but would have thought it within the realms of a query but I take it I am wrong... Whilst I could not have come up with such... Iterative and Recursive are good words to describe exactly what it is. Would have just been far easier in a query as I am laying it out on a...

I am writing a query to calculate a running value, looking at the result of the line above and adjusting the running value in relation to new criteria. Make sense ? For example I have a number of dates which each have a value (a) against them dependant on the value in (a) I want to reward it...