Use the RunSQL action in your query.

Signature
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
> How can I attach a macro to a action querie so i can create a button that
> will run the action querie?