software

I am creating an external data query in excel to reterive data from a SQL
database, one of the fields in the db is a date. When I run the query I want
Excel to asked me for a date range for the data to return.

Can any one tell me what I have to enter into the MS Query Editor in the
query criteria area to bring up a window that asks for the start and end date
of the data that it will reterive?

Thanks in advance for any assistanceThis website will explain what you need to know:

www.rdg.ac.uk/ITS/info/traini...s/excel/query/

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Proquot;Richardquot; wrote:

gt; I am creating an external data query in excel to reterive data from a SQL
gt; database, one of the fields in the db is a date. When I run the query I want
gt; Excel to asked me for a date range for the data to return.
gt;
gt; Can any one tell me what I have to enter into the MS Query Editor in the
gt; query criteria area to bring up a window that asks for the start and end date
gt; of the data that it will reterive?
gt;
gt; Thanks in advance for any assistance
gt;