How to copy values in table?

[macloch]

Good Morning,

I'm a new Access user and I need help in one issue.
I have a table called "nabytki" and I must copy values in nearly 9 000 lines (records).


I must copy values from the selected fields from the line "A" to the line "B" like in picture.

How can I do that?

[ranman256]

use an append query.
the source would be the record you want to copy,
and append to that table.

[June7]

Why duplicate so much data? Should not be so many fields dupicated in two tables.

[macloch]

use an append query.
the source would be the record you want to copy,
and append to that table.

Thx for your answer. I will try to check this tomorrow.

Why duplicate so much data? Should not be so many fields dupicated in two tables.

It's not my idea

[June7]

Okay, explore INSERT SELECT sql syntax.

[macloch]

use an append query.
the source would be the record you want to copy,
and append to that table.

I'm trying do that, but I must do something wrong. Can you please show what I should to do step by step?

[June7]

Tutorial shows syntax for 2 tables but can be adjusted for one table https://www.w3schools.com/sql/sql_in...nto_select.asp

Post your attempt for analysis.

[macloch]

Here you are.

INSERT INTO przesuniecia ( symbol_oddzialu, oznaczenie_spisu, numer_spisu, pozycja_spisu, poprzedni_symbol_oddzialu, poprzedni_oznaczenie_spisu, poprzedni_numer_spisu, poprzedni_pozycja_spisu )
SELECT nabytki.symbol_oddzialu, nabytki.oznaczenie_spisu, nabytki.numer_spisu, nabytki.pozycja_poczatkowa, nabytki.poprz_symbol_oddzialu, nabytki.poprz_oznaczenie_spisu, nabytki.poprz_numer_spisu, nabytki.poprz_pozycja_poczatkowa
FROM nabytki;

[June7]

You probably need a WHERE clause in the SELECT that restricts the records to be copied.

We really don't have enough info to provide detailed guidance.

[macloch]

What kind of the information do you need? I will try to give this.

[June7]

What criteria will identify the specific record(s) to copy? Did you try including WHERE clause?

You show a table. If you want to run this action with code and dynamic parameter, use a form.

[macloch]

I did that. Thank you so much for your support.