Thanks, that worked well. Glenn
"Tom Ogilvy" wrote:
Just use a parameter query. You can assign the parameter to get its value
from a cell.
See Nick Hodges site for an example:
http://nickhodge.co.uk/gui/datamenu/...taexamples.htm
--
Regards,
Tom Ogilvy
"Glenn1203" wrote in message
...
I would like to form a SQL query that would Select Where a column value
equals a value in cell A1. I'm trying to write a macro that will copy the
value from the cell and paste it into a Database Query QueryTable box. Is
there an easier way to do this? Can I paste into a QueryBox?
Help is much appreciated. Glenn