Update Query Help *urgent*

Joined
May 26, 2012
Messages
1
Reaction score
0
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!
 
Back
Top