How to use cell value in MS Query? 1

[DwayneS]

I have date values in two fields in an Excel spreadsheet.

I want to use those dates as criteria in querying data from an Access database. How do I pickup those dates and use them as begin and end date in my query?

Dwayne Streeter, CPA, CITP

http://www.cpe-interactive.com

 

[PHV]

Create a parametized QueryTable with MS-Query, then modify the parameters properties to point to the desired cells.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886