JWColby
jwcolby at colbyconsulting.com
Wed Feb 28 11:45:32 CST 2007
Sorry. This is in Access, QBE grid. 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:37 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Faking an SQL record 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com