insert into

[nicolacantalupo]

I have created this query:
INSERT INTO versamenti2 ( codice_iscrizione, riferimento )
SELECT codice_iscrizione, rif
FROM iscrizioni;
I want that only the current record is appended in the table
iscrizioni2

thanks
by

[Larry Linson]

"nicolacantalupo" <ni*************@libero.itwrote

>I have created this query:
INSERT INTO versamenti2 ( codice_iscrizione, riferimento )
SELECT codice_iscrizione, rif
FROM iscrizioni;
I want that only the current record is appended in the table
iscrizioni2

What "current record"?

If from a Form, you should be able to obtain from the Form or the Form's
RecordSource the unique identifer of the Form's current record, and use it
to construct a WHERE or HAVING clause in your SQL.

Larry Linson
Microsoft Access MVP

[Tom van Stiphout]

On Fri, 18 Jan 2008 19:53:14 GMT, "Larry Linson"
<bo*****@localhost.notwrote:

Larry is right. A SQL statement like:
INSERT INTO versamenti2 ( codice_iscrizione, riferimento )
SELECT codice_iscrizione, rif
FROM iscrizioni
WHERE <primarykey= Forms!YourFormName!YourPrimaryKeyField

will update just a single row.
The HAVING clause is reserved for GROUP BY situations - not your
problem at this time.

-Tom.

>"nicolacantalupo" <ni*************@libero.itwrote

>>I have created this query:
INSERT INTO versamenti2 ( codice_iscrizione, riferimento )
SELECT codice_iscrizione, rif
FROM iscrizioni;
I want that only the current record is appended in the table
iscrizioni2

What "current record"?

If from a Form, you should be able to obtain from the Form or the Form's
RecordSource the unique identifer of the Form's current record, and use it
to construct a WHERE or HAVING clause in your SQL.

Larry Linson
Microsoft Access MVP