call a query by macro with parameters

Hello,

I have a question about macros and querys. I call a macro from a extern
application with some parameters... i.e. ID. Everything works fine. My
question is, how to get this ID into the query.
The query is already created but I want to add a "WHERE mytable.id =
ID" statement into the query and then run it. Can you help me pls ?

thx in advance.

Bye, Andy

re: call a query by macro with parameters

Try to put something like [Enter the needed ID] as the criterion for your ID-field.
When you run the query you will see a popup where you can enter the ID.
Is that what you are looking for?

Arno R

"Andy" <andreas.blenk@blenk-software.de> schreef in bericht news:1147771641.911299.254630@j55g2000cwa.googlegr oups.com...[color=blue]
> Hello,
>
> I have a question about macros and querys. I call a macro from a extern
> application with some parameters... i.e. ID. Everything works fine. My
> question is, how to get this ID into the query.
> The query is already created but I want to add a "WHERE mytable.id =
> ID" statement into the query and then run it. Can you help me pls ?
>
> thx in advance.
>
> Bye, Andy
>[/color]