Eric Barro
ebarro at verizon.net
Wed Feb 28 11:36:40 CST 2007
John, What interface are you using? Is this in the Access query or SQL query analyzer? If you run it in SQL query analyzer it runs fine. Eric -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of JWColby Sent: Wednesday, February 28, 2007 9:25 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Faking an SQL record 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". John W. Colby Colby Consulting www.ColbyConsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Eric Barro Sent: Wednesday, February 28, 2007 12:18 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Faking an SQL record SELECT 'HSomeCompanyName20061227' as MadeUp -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of JWColby Sent: Wednesday, February 28, 2007 9:14 AM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Faking an SQL record I vaguely remember someone supplying a syntax for "faking" a record in SQL without having to actually supply a table name. I want to return a single record from SQL that looks like: HSomeCompanyName20061227 This is not data pulled out of any table, it is just "made up". I can do this by aliasing the three fields and then telling SQL that it came FROM SomeRealTable and then use a distinct clause etc. But I seem to remember some way of doing this without even supplying the name of a real table. Anyone have a clue what I am saying and how to do this? John W. Colby Colby Consulting www.ColbyConsulting.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.446 / Virus Database: 268.18.4/705 - Release Date: 2/27/2007 3:24 PM -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.446 / Virus Database: 268.18.4/705 - Release Date: 2/27/2007 3:24 PM