Update Query, once only

[commandoboy via AccessMonster.com]

Hello everyone,

I import data into a table from a textfile. When the data is imported, there
is one row which is appended to the table. One of the field names is time,
which is displayed in minutes. I wish to display this time in hours. My
original idea was to run an update query to divide the required field by 60.
However the problem is that I only want to update the most recently added
record, and not the whole field.

Please help!!

Thankyou in advance

Ryan

 

[Guest]

If you are using a query to do the import, do the conversion in the query.