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

John,

    If an SQL statement is put directly in SQL view of QBE,  without having first dragged any field into the QBE grid, relevant fields get displayed in the grid only if their names in  SELECT clause are qualified by the table name.

    For example -
    (a) SELECT *  FROM  tbl1 - will not show any field in QBE grid.
    (b) SELECT  tbl1.*  FROM  tbl1 - will result in correct display in QBE grid.

    Note - This is as per tests conducted on Access XP running on Win XP.

A.D.Tejpal
--------------

  ----- Original Message ----- 
  From: John W. Colby 
  To: 'Access Developers discussion and problem solving' 
  Sent: Friday, December 24, 2004 09:04
  Subject: [AccessD] Query SQL correct but not visible in design view


  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