Hi,
I have a table with many records, and I would like to update for one of the fields, the same information as in the first record. Keep in mind that a group of records have the same attribute.
The same problem is easy to solve in EXCEL just by dragging down the info from the above cell - in this way you populate all the records with the same info as the first record, for a specific field.
How can I achieve this using ACCESS?
I want this:
FROM:
1 cost1 cost2
2 cost1
3 cost1
4 cost1
5 cost1
TO:
1 cost1 cost2
2 cost1 cost2
3 cost1 cost2
4 cost1 cost2
5 cost1 cost2
Thank you!
I have a table with many records, and I would like to update for one of the fields, the same information as in the first record. Keep in mind that a group of records have the same attribute.
The same problem is easy to solve in EXCEL just by dragging down the info from the above cell - in this way you populate all the records with the same info as the first record, for a specific field.
How can I achieve this using ACCESS?
I want this:
FROM:
1 cost1 cost2
2 cost1
3 cost1
4 cost1
5 cost1
TO:
1 cost1 cost2
2 cost1 cost2
3 cost1 cost2
4 cost1 cost2
5 cost1 cost2
Thank you!