Updating Null field with previous field

  • Thread starter Thread starter tonydepo
  • Start date Start date
T

tonydepo

Guest
for example I have a table named TBLtest. This table has 3 fields. PlateNo, TicketNo and Type. It is imported as

578bzz 123778 T
F
626bss 128000 T
677ghg 233339 T
865jht 244008 T
F
P

Where ever there is a blank it must update the table to display the previous plateno and ticketno. so the new table should look like this

578bzz 123778 T
578bzz 123778 F
626bss 128000 T
677ghg 233339 T
865jht 244008 T
865jht 244008 F
865jht 244008 P

Please help
 

Users who are viewing this thread

Back
Top Bottom