"insert into" query

  • Thread starter Thread starter Guldo K
  • Start date Start date
G

Guldo K

Hello.
I can't understand how does this kind of query work.
I set it up to look at some strings on a form,
look into a Table for records determined by such strings,
then insert values from both the form and the Table.

So, there are values from two textboxes inserted into
two fields of Table2, then two fields from Table1
inserted into Table2. For the last of them, there's
a "having" statement, depending on another textbox
in the same form. I mean the "having" cell value is
[Forms]![myform]![field1]

This works as a "select" query, but as I turn it into
a "insert into" query, 0 records are processed.

Could you let me understand why?

Thanks a lot,

*Guldo*
 
Hello.
I can't understand how does this kind of query work.
I set it up to look at some strings on a form,
look into a Table for records determined by such strings,
then insert values from both the form and the Table.

So, there are values from two textboxes inserted into
two fields of Table2, then two fields from Table1
inserted into Table2. For the last of them, there's
a "having" statement, depending on another textbox
in the same form. I mean the "having" cell value is
[Forms]![myform]![field1]

This works as a "select" query, but as I turn it into
a "insert into" query, 0 records are processed.

Could you let me understand why?

Thanks a lot,

*Guldo*
Click to expand...

Care to post the SQL of the query? It's more than a bit difficult for
us to tell what is wrong with the query if we can't see the query!
 
John Vinson said:
Care to post the SQL of the query? It's more than a bit difficult for
us to tell what is wrong with the query if we can't see the query!
Click to expand...

Sorry...

INSERT INTO Gestione3 ( prezzo, peso, descrizione, bilancia )
SELECT [Forms]![Accoda]![importo] AS Prezzo, [Forms]![Accoda]![peso] AS Peso, Gestione1.descrizione, Gestione1.bilancia
FROM Gestione1, Gestione3
GROUP BY [Forms]![Accoda]![importo], [Forms]![Accoda]![peso], Gestione1.descrizione, Gestione1.bilancia
HAVING (((Gestione1.bilancia)=[Forms]![Accoda]![bilancia]));

Thanks,

*Guldo*
Access 2k
 
INSERT INTO Gestione3 ( prezzo, peso, descrizione, bilancia )
SELECT [Forms]![Accoda]![importo] AS Prezzo, [Forms]![Accoda]![peso] AS Peso, Gestione1.descrizione, Gestione1.bilancia
FROM Gestione1, Gestione3
GROUP BY [Forms]![Accoda]![importo], [Forms]![Accoda]![peso], Gestione1.descrizione, Gestione1.bilancia
HAVING (((Gestione1.bilancia)=[Forms]![Accoda]![bilancia]));
Click to expand...

I think the trouble is that you're trying to Group By fields - the
Form references - which aren't in the table. Change the Group By
aggregate function under the two form references to Expression - or,
since you're not obviously doing any totalling, simply turn off the
summation button.
 
John Vinson said:
I think the trouble is that you're trying to Group By fields - the
Form references - which aren't in the table. Change the Group By
aggregate function under the two form references to Expression - or,
since you're not obviously doing any totalling, simply turn off the
summation button.
Click to expand...

That worked great. Thanks for your help. ^_^

*Guldo*
 
Back
Top