Working with data in dated subfolders

C

CharlesBanks

I am attempting to use the Source Property to connect to text files that are
contained in dated subfolders. Currently I have a ActiveX control that places
a date in a table. I would like to take that date and add it to the FROM
clause in my related Qry.

For Example - Date = 11/16/2004

Select EMP.FirstName
FROM EMP IN '\\ServerName\Data\20041116' [dBASE IV;]

When the user selects a different date (11/17/2004)
I would like my Qry updated to be:

Select EMP.FirstName
FROM EMP IN '\\ServerName\Data\20041117' [dBASE IV;]

Any suggestions would be greatly appreciated.
 
Top