Hi,
SQL select command does not seem to work when I am saying
"set <rst> = <db>.openrecordset(<sqlstring>).
I have tried everything. The error that comes on is that the no of parameters is less or some thing like that
Instead, now I am trying to use a "do until <rst>.eof " loop with a if-then-else statement to select records.
While I am using this method can anyone tell me
1. how to copy records that are selected (all fields) into a temp table which has the same structure as the source table?
2. how to delete all the records in the temp table once I have finished using it ?