M
mauken
I import a table of yesterday's racing results. I want to adjust the length
and time fields. time increases by .2 per length lengths are added. I'm new
to access and would appreciate full instructions. selection by rac_id would
keep things tidy.
rac_id, ord, length, name, time
123, 1,0,miss muffet,180.60 winner
123, 2,10,black beauty,180.60 becomes 10 182.60
123, 3,.5,wilko,180.60 becomes 15 183.60
124,1,0, jacko,240.48 winner
124,2,5,wacko,240.48 becomes 5 241.80
124,3,8,dolly,240.48 becomes 13 243.40
regards, maurice.
and time fields. time increases by .2 per length lengths are added. I'm new
to access and would appreciate full instructions. selection by rac_id would
keep things tidy.
rac_id, ord, length, name, time
123, 1,0,miss muffet,180.60 winner
123, 2,10,black beauty,180.60 becomes 10 182.60
123, 3,.5,wilko,180.60 becomes 15 183.60
124,1,0, jacko,240.48 winner
124,2,5,wacko,240.48 becomes 5 241.80
124,3,8,dolly,240.48 becomes 13 243.40
regards, maurice.