Hi,

You can use a QueryTable in excel:
- menu Data Get (or Import) External Data New Database QUery. The
'Choose Data Source' pops up.
- choose 'MS Access Database' from the Databases tab and make sure the
checkbox 'Use the Query Wizard...' is checked. Click OK.
- The Select Database dialog pospup. Choose your mdb file. click OK.
- follow the wizard, you'll be able to filter on any field so you can filter
on your date field.

--
Regards,
Sébastien
<http://www.ondemandanalysis.com


"Darron Ross" wrote:

thanks for any help,

I have a small SQL query(shown below) that will retrieve some date from .mdb
according to the date selected. It will get the data greater then the data
selected or the date less or equel to selected date. I need to select between
two dates and get the data from that. Like I select 11/15/2005 00:00:00 to
11/31/2005 00:00:00 and only the data from those two dates are returned.

Thanks again for any help. darron


SQL Query-------------------------------------


SELECT TrendAnalogJoin.DateTime, TrendAnalogJoin.TagName,
TrendAnalogJoin.Value
FROM TrendAnalogJoin TrendAnalogJoin
WHERE (TrendAnalogJoin.DateTime'2005/10/28 23:59:00')
ORDER BY TrendAnalogJoin.DateTime