access query

[Mark]

I have a access query that prompts for a date range when
run. I need to call the query from Excel. When I run the
query from Excel I'm not prompted for the date range and
the query fails. Is there a way to call the query and be
prompted for the date range?

Thanks in advance for you help!

 

[Guest]

I think it is related to the following MSKB article:

http://support.microsoft.com/?id=207143

Try the work-around as suggested by the article.

HTH
Van T. Dinh
MVP (Access)