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
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