Hey everyone, need some urgent help if possible. (using MS Access 2007)
Basically I have two tables. (Fields are Long Time)
Table 1 - FinishTime
Table 2 - PersonalBest
I need to update the PersonalBest field from the values in FinishTime using a update query but making sure that the values in FinishTime would be lower (as it would be a quicker finish) than the PersonalBest then it should update.
Any ideas?
Thanks!
Basically I have two tables. (Fields are Long Time)
Table 1 - FinishTime
Table 2 - PersonalBest
I need to update the PersonalBest field from the values in FinishTime using a update query but making sure that the values in FinishTime would be lower (as it would be a quicker finish) than the PersonalBest then it should update.
Any ideas?
Thanks!