[AccessD] Query SQL correct but not visible in design view

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/





More information about the AccessD mailing list