Hi,
I'm using ODBC to connect to a data source. MS query tables the record
that, in turn, Excel populates for further manipulation.

I would like to restrict the date range of the data to MS query an
therefore to Excel by specifiying the dates in cells within Excel.

For example: Start date (A1) 01/04/04 End date (A2) 20/04/04

What criteria/formula would have be set in MS query to read the lowe
and upper date ranges in excel cells A1 & A2 sheet 1, prior t
populating sheet 2 with the external data?

Is there a better way perhaps?

Many thanks

bean

--
Message posted from http://www.ExcelForum.com

bean

You need two parameters that are based on a cell. See here

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

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


"Lordbean " wrote in message
...
Hi,
I'm using ODBC to connect to a data source. MS query tables the records
that, in turn, Excel populates for further manipulation.

I would like to restrict the date range of the data to MS query and
therefore to Excel by specifiying the dates in cells within Excel.

For example: Start date (A1) 01/04/04 End date (A2) 20/04/04

What criteria/formula would have be set in MS query to read the lower
and upper date ranges in excel cells A1 & A2 sheet 1, prior to
populating sheet 2 with the external data?

Is there a better way perhaps?

Many thanks

bean'


---
Message posted from http://www.ExcelForum.com/

Many thanks Dic

--
Message posted from http://www.ExcelForum.com