Dynamic Query

[gundie]

I need to write a program to dynamically compare two tables. First the program imports and create tables of a list of weekly spreadsheet from a folder (1/1/2006, 1/8/2006, 1/15/2006...). The user will need to select tables to compare via combo boxes (for example, the user selects 1/1/2006 and 1/15/2006). How can I write a query that will compare the user selected tables based on the input?

I hope my explanation is clear.

 

[PHV]

And what have you tried so far ?

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