John W. Colby
jwcolby at colbyconsulting.com
Sat Dec 25 12:39:56 CST 2004
That would explain it. I do not use the table qualifier unless the field
name is the same in different tables which is generally not the case in my
systems.
John W. Colby
www.ColbyConsulting.com
Contribute your unused CPU cycles to a good cause:
http://folding.stanford.edu/
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of A.D.Tejpal
Sent: Saturday, December 25, 2004 12:23 PM
To: Access Developers discussion and problem solving
Subject: Re: [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
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com