[AccessD] Faking an SQL record

Wed Feb 28 11:48:38 CST 2007

Hi John

  SELECT TOP 1 
    "HSomeCompanyName20061227" AS Company
  FROM 
    MSysObjects;

/gustav

>>> jwcolby at colbyconsulting.com 28-02-2007 18:24:46 >>>
Eric, if I don't include a FROM clause, the bang symbol doesn't ungray and
allow me to run the query.  If I put in FROM SomeMadeUpTableName I get an
error when I run the query that it "can't find SomeMadeUpTableName".