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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top