Export certain cells in Access Table (1 Viewer)

[Gizem]

Hello together,

i have to export certain cells in an Access table. When i deal just with tables or query than i work with this code:

Dim SQLInsert As String
SQLInsert = " INSERT INTO Table3(P_NAME) " _
& " SELECT F_Projekt.P_NAME"  _
& " FROM F_Projekt"  _
& " WHERE GEWICHT_KG <> '0' "

CurrentDb.Execute SQLInsert

But i have to export some cells from a report to an Access Table. And here i get a error 3131: syntax error in FROM clausel..

 

[June7]

This basically duplicates your other thread.

Is GEWICHT_KG a number field?

Nothing in that code indicates reference to a report. So where is the code you tried that failed?

 

[Gizem]

This basically duplicates your other thread.

Is GEWICHT_KG a number field?

Nothing in that code indicates reference to a report. So where is the code you tried that failed?

Yes GEWICHT_KG is a number field.
And below is my code which doesn't work.

F_Projekt is the name of my report

 

[June7]

I am responding in your other thread.