John W. Colby
jwcolby at colbyconsulting.com
Thu Dec 23 21:34:25 CST 2004
I am building a SQL statement "on the fly" which essentially compares matching fields in two different tables - Tbl1.Lname <> Tbl2.Lname. The SQL runs but only the tables and their joins are visible in the QBE grid. There are no fields visible etc. Does anyone understand what causes Access to do this? I have had the same thing occur even with something as simple as a SELECT * from tbl1 inserted into the SQL view. Tbl1 is displayed, but nothing in the grid. The query executes correctly. Anyone? John W. Colby www.ColbyConsulting.com Contribute your unused CPU cycles to a good cause: http://folding.stanford.edu/