Have a good data entry form that fills table 1 in access
like :

Dia Código Ocorrencia HE HI
1 7 p 0 1,5
2 7 p 0 1,5
3 7 a 0 1,5
1 14 p 1 0
2 14 p 2 0
3 14 p 0 0


Have a good lay-out report in access that needs source table 2
like :

Código Evento Campo1 Campo2 Campo3
7 Ocorrencia p p a
7 HE 0 0 0
7 HI 1,5 1,5 1,5
14 Ocorrencia p p p
14 HE 1 2 0
14 HI 0 0 0

Question:
How do I map the data from table 1 to table 2 in access
using programming?
I dont want to go to excel to use the transpose copy.
Comment:
For each same data under Field("Código") there will be
as many data under Field("Dia") as the days of the month.
For simplicity we have three days.

This is my last SOS asking for help.Why do I have an icon to delete it?
How do I erase the delete icon?
Tks for any help!

try to create a union query (SQL qry)

Thank u Stanny,
I will study SQL before i try your approach.
Tks for the help.

try the something like this in the SQL query view

SELECT table1.* from table1
UNION Select table2.* from table2;

thanks again Stanny!
As soon as i have time to try your way i will let u know.Unfortunatelly that will mean at least a week.

Have tried SQL query with no progress.I am trying arrays now and by the way need help too.
Tks for the help.