I am linking to another program's data files and the date/time is broken up. So I use a query to assemble the dates. Then I use the querys in a query to retrieve the data and dates for the data I want. If I do two querys in a query it works. If I do three querys in a query the computer starts processing the query but never finishes. Well it doesn't finish after 25 minutes and the data files are not that big. Like 200k each. Anyone know what is going on? I tried this on another computer and it worked with three querys in a query off the same data. I am running Windows 2k and Access 2000.
