Kevin

Try here

http://www.dicks-clicks.com/excel/Ex....htm#ChangeSQL

Also, have a look at the Parameters page. Often a parameter is a better way
than handling it through code, but not always.

--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com

"Kevin Depree" wrote in message
...
Hi,

I have sucsesfully created a query that looks at my database, but I want
to create a macro which changes some of the 'criteria' withing the query
that can be run without having to go back into query every time the change
is made.

Can anyone help

Kevin Depree