Hello,
in order to get a better data base I want to fill some empty fields in my data record with values from another data record.
In my table I have 5 columns, I created my table here very quickly because I'm not allowed to post pictures:
ID | Sales Receipt | Description | City | Country
1 | 21646521 | MEDICAL CENTER | San Diego | USA
2 | ________ | _______________ | Denver | _____
3 | 65475101 | LITTLETON HOSP | LITTLETON | USA
As you can see I have data records that are full, so all fields have something written in it. But then I also have a data record where there is a only one value written, the rest of the columns of this record is empty.
So now I want to create a procedure that should copy the values of the existing fields into the ones that are empty until a new sales receipt number comes in that column.
And it should perform this with my whole table.
Hope you can understand what I want to do. Does someone have a nice way on how to do it?
Thanks in advance,
Heide
Copy values into following fields
in order to get a better data base I want to fill some empty fields in my data record with values from another data record.
In my table I have 5 columns, I created my table here very quickly because I'm not allowed to post pictures:
ID | Sales Receipt | Description | City | Country
1 | 21646521 | MEDICAL CENTER | San Diego | USA
2 | ________ | _______________ | Denver | _____
3 | 65475101 | LITTLETON HOSP | LITTLETON | USA
As you can see I have data records that are full, so all fields have something written in it. But then I also have a data record where there is a only one value written, the rest of the columns of this record is empty.
So now I want to create a procedure that should copy the values of the existing fields into the ones that are empty until a new sales receipt number comes in that column.
And it should perform this with my whole table.
Hope you can understand what I want to do. Does someone have a nice way on how to do it?
Thanks in advance,
Heide
0 commentaires:
Enregistrer un commentaire