Unfortunately, this wont do it. The reason is that the query is a union of
three queries and each have a where clause. In order to facilitate this I
really do need to use parameters.

Thanks in Anticipation.


"moon" wrote in message
. ..

"Goofy" schreef in bericht
...
Thats really great, thanks for your help. The only thing missing here is
how to add the parameters to the query because it has two.

Cheers

I know. Sorry.
I saw it after posting :-p


Params can be passed in the SQL-string, like:
db.Open "SELECT * FROM [QUERY] WHERE fieldname=fieldvalue", dc