I
iccsi
I use VBA code to build SQL statment to insert a crosstab to a temp
table.
The SQL is like following:
INSERT INTO tblTmep (Field1, Field2, Field3)
SELECT DISCTINCT CField1, CField2, CField3 FROM MyCrosstab
The SQL works fine.
I got parameter expected eror message at run time.
I run SQL against the databases and realize that the crosstab does not
return at run time.
I set breakpoint before CurrentDB.Execute the crosstab returns no
records and get error message when run the execute.
After I clcick on end debug and try the SQL and Crosstab query which
returns records and SQL insert the crosstab query in to my temp table.
I just wonder does corsstab has any delay while running to insert in
to temp table or I am on the arong track.
Your information is great appreciated,
table.
The SQL is like following:
INSERT INTO tblTmep (Field1, Field2, Field3)
SELECT DISCTINCT CField1, CField2, CField3 FROM MyCrosstab
The SQL works fine.
I got parameter expected eror message at run time.
I run SQL against the databases and realize that the crosstab does not
return at run time.
I set breakpoint before CurrentDB.Execute the crosstab returns no
records and get error message when run the execute.
After I clcick on end debug and try the SQL and Crosstab query which
returns records and SQL insert the crosstab query in to my temp table.
I just wonder does corsstab has any delay while running to insert in
to temp table or I am on the arong track.
Your information is great appreciated,