DWUTKA at marlow.com
DWUTKA at marlow.com
Wed May 19 10:41:09 CDT 2004
Yeah, wrote that before my first cup of coffee. Sorry. Drew -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Bobby Heid Sent: Wednesday, May 19, 2004 10:21 AM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Select statements to get column definitions? Wouldn't that be 'That would create a field called SomeOtherName' instead of 'That would create a field called MyField'? Bobby -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of DWUTKA at marlow.com Sent: Wednesday, May 19, 2004 11:13 AM To: accessd at databaseadvisors.com Subject: RE: [AccessD] Select statements to get column definitions? As far as I know, the only 'options' you have with a SELECT statement is the AS keyword. ie, you can say SELECT MyField AS SomeOtherName FROM tblMyTable. That would create a field called MyField, which would be the 'caption' of a field. Not sure what you are actually trying to do though, so if you explain what you are trying to accomplish, I may be able to help a little more. Drew -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Arthur Fuller Sent: Wednesday, May 19, 2004 10:01 AM To: AccessD Subject: [AccessD] Select statements to get column definitions? Is there a way to write a SELECT statement so that its result looks similar to the display you see when you design a table? That is, column name, type and description -- I don't care about the other attributes at the moment. I know you can use the Documenter but I want the results as a table if possible. TIA, Arthur -- _______________________________________________ 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 -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com