C
Chris
Hi All, I know it sounds like a normalisation nightmare but it's not
(honest)
I have generated a query from access to select rows from a table. I would
like to copy these rows to another table by code ( code run by clicking
button on a form).
I'm really not sure of the syntax for this.
For one row I would have
Dlookup (value 1, Value2)
Insert into tbltable ( Column1, column2)
Values (value1, value2).
However, this will have multiple rows so it will have to be something like
select Query
Do Until query rows = 0
Insert into tbltable ( Column1, column2)
Values (value1, value2).
Loop
end Do
Could someone please fill in please?
(honest)
I have generated a query from access to select rows from a table. I would
like to copy these rows to another table by code ( code run by clicking
button on a form).
I'm really not sure of the syntax for this.
For one row I would have
Dlookup (value 1, Value2)
Insert into tbltable ( Column1, column2)
Values (value1, value2).
However, this will have multiple rows so it will have to be something like
select Query
Do Until query rows = 0
Insert into tbltable ( Column1, column2)
Values (value1, value2).
Loop
end Do
Could someone please fill in please?